RE: bind_param_inout + DBD::ODBC

2005-10-13 Thread Jeff Urlwin
Can you please do the following: 1) get a dbi trace (level 9) 2) try a simpler function (1 with a single varchar, for example) Thanks, Jeff From: Stephen More [mailto:[EMAIL PROTECTED] Sent: Thursday, October 13, 2005 9:20 AM

Re: DBD::DBM and hashrefs

2005-10-13 Thread Ron Savage
On Thu, 13 Oct 2005 10:11:41 -0700, Ryan Tate wrote: Hi Ryan > $Tied_hash{ $id } = { key1 => $val1, key2 => $val2 }; But a hash is just an array of key/value pairs. Can't you just try: $T{$id} = [\%hash]; What happens? -- Cheers Ron Savage, [EMAIL PROTECTED] on 14/10/2005 http://savage.net.au/

Re: DBD::Oracle and $sth->{PRECISION}

2005-10-13 Thread Tim Bunce
On Thu, Oct 13, 2005 at 10:03:39AM -0400, Eric Lenio wrote: > On Thu, Oct 13, 2005 at 09:32:33AM +0100, Tim Bunce wrote: > > On Thu, Oct 13, 2005 at 01:15:21AM -0400, Eric Lenio wrote: > > > Hi, > > > > > > In perl 5.8.3, DBD::Oracle 1.14, DBI 1.47 I get expected values when I > > > look at > > >

DBD::DBM and hashrefs

2005-10-13 Thread Ryan Tate
Hello, I have a question about using DBD::DBM in MLDBM mode: does anyone know whether it works with hashrefs as values, or just arrayrefs? Reading the docs and trying the module leads me to believe it only works with data like: $Tied_hash{ $id } = [ $val1, $val2 ]; But all the data in my DB fil

Re: Execute failed: ORA-01026: multiple buffers of size > 4000 in the bind list (DBD: oexec error) - update

2005-10-13 Thread Tim Bunce
On Thu, Oct 13, 2005 at 07:35:53AM -0400, Moon, John wrote: > From: Tim Bunce [mailto:[EMAIL PROTECTED] > Sent: Friday, October 07, 2005 12:19 PM > To: Jared Still > Cc: Moon, John; 'dbi-users@perl.org' > Subject: Re: Execute failed: ORA-01026: multiple buffers of size > 4000 in > the bind list (D

DBD::Oracle and ErrCount

2005-10-13 Thread Adriano Ferreira
DBI docs say: The ErrCount attribute was added in DBI 1.41. Older drivers may not have been updated to use set_err() to record errors and so this attribute may not be incremented when using them. DBD::Oracle 1.16 is one of those drivers that are not using set_err() yet? Regards, Adr

Re: DBD::Oracle and $sth->{PRECISION}

2005-10-13 Thread Eric Lenio
On Thu, Oct 13, 2005 at 05:34:15PM +0100, Tim Bunce wrote: > On Thu, Oct 13, 2005 at 10:03:39AM -0400, Eric Lenio wrote: > > On Thu, Oct 13, 2005 at 09:32:33AM +0100, Tim Bunce wrote: > > > On Thu, Oct 13, 2005 at 01:15:21AM -0400, Eric Lenio wrote: > > > > Hi, > > > > > > > > In perl 5.8.3, DBD::

Re: DBD::Oracle and $sth->{PRECISION}

2005-10-13 Thread Eric Lenio
On Thu, Oct 13, 2005 at 09:32:33AM +0100, Tim Bunce wrote: > On Thu, Oct 13, 2005 at 01:15:21AM -0400, Eric Lenio wrote: > > Hi, > > > > In perl 5.8.3, DBD::Oracle 1.14, DBI 1.47 I get expected values when I look > > at > > $sth->{PRECISION} to retrieve the lengths of varchar2 columns for a given

Re: bind_param_inout + DBD::ODBC

2005-10-13 Thread Stephen More
I have tried the following code: my( $sth ) = $dbh->prepare ("{call PGMRPGMLIB.SYSSTATS(?, ?, ?)}"); my( $asp ) = undef; my( $cpu ) = undef; my( $jobs ) = undef; $sth->bind_param_inout(1, \$asp, 100, DBI::SQL_FLOAT ); $sth->bind_param_inout(2, \$cpu, 100, DBI::SQL_FLOAT ); $sth->bind_param_inout(3

RE: Execute failed: ORA-01026: multiple buffers of size > 4000 in the bind list (DBD: oexec error) - update

2005-10-13 Thread Moon, John
From: Tim Bunce [mailto:[EMAIL PROTECTED] Sent: Friday, October 07, 2005 12:19 PM To: Jared Still Cc: Moon, John; 'dbi-users@perl.org' Subject: Re: Execute failed: ORA-01026: multiple buffers of size > 4000 in the bind list (DBD: oexec error) On Fri, Oct 07, 2005 at 07:02:43AM -0700, Jared Still

Re: DBD::Oracle and $sth->{PRECISION}

2005-10-13 Thread Tim Bunce
On Thu, Oct 13, 2005 at 01:15:21AM -0400, Eric Lenio wrote: > Hi, > > In perl 5.8.3, DBD::Oracle 1.14, DBI 1.47 I get expected values when I look at > $sth->{PRECISION} to retrieve the lengths of varchar2 columns for a given > table. > > I'm now testing perl 5.8.7, DBD::Oracle 1.16, and DBI 1.48

RE: bind_param_inout + DBD::ODBC

2005-10-13 Thread Jeff Urlwin
DBD::ODBC support bind_param_inout... The best way to see an example is to look at the tests for SQLServer and Oracle. I don't have a DB2 server to test against, at the moment, but I've tested against both SQLServer and Oracle. Jeff > -Original Message- > From: Stephen More [mailto:[EM