Re: Problem populating execute using @array.

2002-09-19 Thread Tim Bunce
Use trace. Use trace. Use trace. Tim. On Wed, Sep 18, 2002 at 02:35:02PM -0400, Dolan, Mark wrote: I am trying to update a table in an Oracle database. I am reading an input file which has the column names for the database as the first record in the file. The data begins in the second row.

RE: Problem populating execute using @array.

2002-09-19 Thread NYIMI Jose (BMB)
Message- From: Tim Bunce [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 10:59 AM To: Dolan, Mark Cc: Perl Users Help (E-mail) Subject: Re: Problem populating execute using @array. Use trace. Use trace. Use trace. Tim. On Wed, Sep 18, 2002 at 02:35:02PM -0400, Dolan

Re: Problem populating execute using @array.

2002-09-19 Thread Hardy Merrill
NYIMI Jose (BMB) [[EMAIL PROTECTED]] wrote: Hello Tim, I'm very interested by DBI-trace method. I gave a look in DBI.pm, I can't find the implementation. How about trying perldoc DBI at a command prompt - then search(using the forward slash) for trace. -- Hardy Merrill Senior

RE: Problem populating execute using @array.

2002-09-19 Thread NYIMI Jose (BMB)
-Original Message- From: Hardy Merrill [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 1:26 PM To: NYIMI Jose (BMB) Cc: Tim Bunce; Dolan, Mark; Perl Users Help (E-mail) Subject: Re: Problem populating execute using @array. NYIMI Jose (BMB) [[EMAIL PROTECTED

Re: Problem populating execute using @array.

2002-09-19 Thread Michael A Chase
: Problem populating execute using @array. NYIMI Jose (BMB) [[EMAIL PROTECTED]] wrote: Hello Tim, I'm very interested by DBI-trace method. I gave a look in DBI.pm, I can't find the implementation. How about trying perldoc DBI at a command prompt - then search(using

RE: Problem populating execute using @array.

2002-09-19 Thread NYIMI Jose (BMB)
It's in the source archive, DBI-1.30.tar.gz. Extract all the files and grep for 'trace'. Note that trace() itself is That is what I did and I thought that I will find some where( not in lib/DBI/PurePerl.pm file) a line beginning with: sub trace{ None Is that part written in C ?

Re: Problem populating execute using @array.

2002-09-19 Thread Michael A Chase
On Thu, 19 Sep 2002 16:05:33 +0200 NYIMI Jose (BMB) [EMAIL PROTECTED] wrote: It's in the source archive, DBI-1.30.tar.gz. Extract all the files and grep for 'trace'. Note that trace() itself is That is what I did and I thought that I will find some where( not in lib/DBI/PurePerl.pm

RE: Problem populating execute using @array.

2002-09-19 Thread NYIMI Jose (BMB)
Yes. There is more to DBI than the Perl sections. There are also .xs and .c files. Keep looking for 'trace', not 'sub trace'. Mamamiya ! :-) Thanks ... DISCLAIMER This e-mail and any attachment thereto may contain information which is confidential and/or protected by

Problem populating execute using @array.

2002-09-18 Thread Dolan, Mark
I am trying to update a table in an Oracle database. I am reading an input file which has the column names for the database as the first record in the file. The data begins in the second row. I read the first record to pull off the column names. I create the sql using placeholders. I then read

Re: Problem populating execute using @array.

2002-09-18 Thread Hardy Merrill
What are the columns defined as(data types)? Looks to me like at least one of the columns is defined as an INTEGER, or another form of a number, and you are trying to feed it a string value. HTH. -- Hardy Merrill Senior Software Engineer Red Hat, Inc. Dolan, Mark [[EMAIL PROTECTED]] wrote:

RE: Problem populating execute using @array.

2002-09-18 Thread Fox, Michael
[mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 4:35 AM To: Perl Users Help (E-mail) Subject: Problem populating execute using @array. I am trying to update a table in an Oracle database. I am reading an input file which has the column names for the database as the first record