Re: problem using table_info and column_info with DBD::Proxy

2006-04-18 Thread Allan Dyer
On 18 Apr 2006 at 23:00, Tim Bunce wrote: > On Mon, Apr 10, 2006 at 03:14:21PM +0800, Allan Dyer wrote: > > > > > > > > I've found that the problem with table_info has been reported three > > > > times before in this group: > > > > > > Here's how I call table_info(...). I have not used DBD::Proxy.

Re: problem using table_info and column_info with DBD::Proxy

2006-04-18 Thread Tim Bunce
On Mon, Apr 10, 2006 at 03:14:21PM +0800, Allan Dyer wrote: > > > > > > I've found that the problem with table_info has been reported three > > > times before in this group: > > > > Here's how I call table_info(...). I have not used DBD::Proxy. > Who's maintaining DBD::Proxy? Perhaps I should con

Re: last insert id

2006-04-18 Thread Tim Bunce
On Tue, Apr 18, 2006 at 01:37:47AM -, Greg Sabino Mullane wrote: > > >> DBI doc last_insert_id() "For some drivers the $catalog, $schema, > >> $table, and $field parameters are required (e.g., Pg), for others > >> they are ignored (e.g., mysql)." > > > > Right. That's why they are undef for My

Re: dump_results

2006-04-18 Thread Tim Bunce
On Thu, Apr 13, 2006 at 03:22:19PM -0700, Loo, Peter # PHX wrote: > Hi, > > I am passing the correct arguments to dump_results, but it appears that > the records are not getting separated with new line. > > $maxlen = 500; > $lsep = '\n'; > $fsep = '|'; > $fh = \*FH; > > $rows = $sth->dump_res

Re: Bad int8 external representation "" (SQL-HY000)(DBD: st_execute/SQLExecute err=-1)

2006-04-18 Thread Ron Savage
On Tue, 18 Apr 2006 11:44:50 -0700, Loo, Peter # PHX wrote: Hi Peter > [unixODBC]ERROR: copy: line 1, Bad int8 external representation "" > (SQL-HY000)(DBD: st_execute/SQLExecute err=-1) Line 1, eh? First attempt to insert data? Did you try chomp-ing the line? -- Cheers Ron Savage, [EMAIL PROT

Bad int8 external representation "" (SQL-HY000)(DBD: st_execute/SQLExecute err=-1)

2006-04-18 Thread Loo, Peter # PHX
Hello All, I am attempting to INSERT into a table while reading in from a piped delimited file and am getting the following error: [unixODBC]ERROR: copy: line 1, Bad int8 external representation "" (SQL-HY000)(DBD: st_execute/SQLExecute err=-1) The destination table (Netezza) layout is (38 c

Re: problem DBD-Oracle-1.17 linux enterprise AS

2006-04-18 Thread Teemu Kivioja
Hi, I had the same problem in a similar system (Oracle 10.1, Enterprise Linux AS). A script running many queries always failed but at a different place at each run. The problem vanished after running the Patch 3612581 for the Oracle bug: Bug 3612581 OERI[kpofdr-long] can occur on SELECT Bes

Re: DBD::Oracle install problems

2006-04-18 Thread MIKE VANOLE
Upgrading is something I would love to do, but can't at this time. I have, however, tried DBD-Oracle 1.15 and 1.16 with the same error. I was hoping 1.17 would work. I was glad to see it available. I'm pretty sure it's an Oracle installation or evnironment issue. I just don't know where else to lo

RE: Semantics of InactiveDestroy

2006-04-18 Thread Garrett, Philip \(MAN-Corporate\)
> -Original Message- > From: Aleksander Adamowski [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 18, 2006 4:39 AM > To: dbi-users@perl.org > Subject: Semantics of InactiveDestroy > > Hi! > > I have a problem with parsing the documentation regarding the > "InactiveDestroy" attribute on

Semantics of InactiveDestroy

2006-04-18 Thread Aleksander Adamowski
Hi! I have a problem with parsing the documentation regarding the "InactiveDestroy" attribute on DB handles. Citing the documentation: "InactiveDestroy" (boolean) The "InactiveDestroy" attribute can be used to disable the *database engine* related effect of DESTROYing a handl

Re: last insert id

2006-04-18 Thread Dr.Ruud
Ron Savage schreef: > Dr.Ruud: >> [ /mysql|Pg/ ] >> Notice that 'CertainlyNotPgAtAll' matches, so maybe you were >> looking for /\A(?:mysql|pg)\z/i > > Nope. Method db_vendor() extracts the vendor's name from the connect > string passed to DBI, so I don't see how it could return that :-))). Is i