to insert data? Did you try chomp-ing the
line?
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 19/04/2006
http://savage.net.au/index.html
Let the record show: Microsoft is not an Australian company
Peter Loo
Worldwide Consulting, Inc.
Phoenix, Arizona
U.S.A.
Hi Ron,
Yes, I should have sent more details, but I was just hoping that
someone has seen this and have a quick answer.
Peter
--- Ron Savage [EMAIL PROTECTED] wrote:
On Fri, 14 Apr 2006 12:13:40 -0700 (PDT), Peter Loo wrote:
Hi Peter
Bad int8 external representation (SQL-HY000) (DBD
;
return($sth);
} #=== (End of sub_executeBindFromInputFile)
When I handle the insert directly out of a select, it appears to work.
Can you please tell me what I am doing wrong?
Thanks.
Peter
Peter Loo
Worldwide Consulting, Inc.
Phoenix, Arizona
U.S.A.
at
any price.
My opinion
--
Peter Loo
Worldwide Consulting, Inc.
Phoenix, Arizona
U.S.A.
as:
$stmtType = insert if $sqlString =~ /^\s+insert/i;
On 4/2/06, Peter Loo [EMAIL PROTECTED] wrote:
Hi Jeffrey,
It is a simple SELECT statement with the following columns from one
table in Oracle then I am using Perl DBI ODBC driver to do an
INSERT
into the same table in Netezza. Netezza
-{Statement}. Are you
checking
for errors at the prepare?
On 4/1/06, Peter Loo [EMAIL PROTECTED] wrote:
Hi Martin,
The value for $dbh-{Statemet} is as follows:
insert into p_dlvrb_study_attributes (dlvrb_gid, study_gid,
client_gid,
slsfc_gid, mkt_def_gid, mkt_def_desc
. Evans [EMAIL PROTECTED] wrote:
Peter Loo wrote:
Hi,
I am trying to pass an array reference to $sth-execute and I am
getting the following error:
DBD::ODBC::st execute failed: called with 38 bind variables when 0
are
needed at /usr/local/apps/common/devl/bin/GlobalRoutines.pm line 42
($$$) {
local ($dbh, $sth, $bindVar) = @_;
$sth-execute(@$bindVar) || die $dbh::errstr;
return($sth);
}
Will someone please help me understand this error message?
Thanks in advance.
Peter
Peter Loo
Worldwide Consulting, Inc.
Phoenix, Arizona
U.S.A.
Hi Michael,
1) $DICEpackage is a store procedure we use internally.
2) The reason that $dbh-prepare is in loop to dynamically handle multiple
tables.
3) I have tried bind variables with commas and yet it didn't work.
4) {} is a style I had adopted to identify that a variable was previously