Re: $sth->execute(@$bindVars) is outputting an error

2006-04-03 Thread Peter Loo
Hi Jeffrey, I have found the culprit. It is in the calling program. Instead of using $d_sth like the original program, someone made a change and didn't tell me. I was looking at the copy instead of the one that was having the problem. $d_dbh = sub_prepare($d_dbh, $sqlString); I have made som

Re: $sth->execute(@$bindVars) is outputting an error

2006-04-03 Thread Jeffrey Seger
I'm posting this back to the list in case anyone else wants to see it. First thing I see is that the number of ? placeholders doesn't appear to be right. I whittled it down to a 2 column table and used your sub_insert to build an insert statement: sub sub_insert($$) { my ($tblName, $columns)

Re: Multiple Oracle Versions

2006-04-03 Thread Alexander Foken
Why should one want to do that? Use the newest available Oracle client and connect to any Oracle server you like. Let Oracle handle the differences between 8, 9 and 10. Alexander On 03.04.2006 17:34, Parikh Sanjeev - sparik wrote: All, Is it possible to have Perl DBI Oracle compiled again

RE: Multiple Oracle Versions

2006-04-03 Thread Reidy, Ron
Sure, installed in different locations. -Original Message- From: Parikh Sanjeev - sparik [mailto:[EMAIL PROTECTED] Sent: Monday, April 03, 2006 9:34 AM To: dbi-users@perl.org Subject: Multiple Oracle Versions All, Is it possible to have Perl DBI Oracle compiled against multiple vers

Multiple Oracle Versions

2006-04-03 Thread Parikh Sanjeev - sparik
All, Is it possible to have Perl DBI Oracle compiled against multiple version of oracle homes 8i/9i/10g? Sanjeev Parikh *** The information contained in this communication is confidential, is intended only for the use

RE: Problem on Solaris 8 64-bit.

2006-04-03 Thread Garrett, Philip \(MAN-Corporate\)
> -Original Message- > From: Rhugga Harper [mailto:[EMAIL PROTECTED] > Sent: Monday, April 03, 2006 10:39 AM > To: Jonathan Leffler > Cc: dbi-users@perl.org > Subject: Re: Problem on Solaris 8 64-bit. > > On 3/30/06, Jonathan Leffler <[EMAIL PROTECTED]> wrote: > > > > On 3/30/06, Rhugg

Re: Problem on Solaris 8 64-bit.

2006-04-03 Thread Rhugga Harper
On 3/30/06, Jonathan Leffler <[EMAIL PROTECTED]> wrote: > > > > On 3/30/06, Rhugga Harper <[EMAIL PROTECTED]> wrote: > > > > I'm running Oracle 10.2.0.1 on Solaris 8 64-bit. I running DBI 1.50, > > DBD::Oracle 1.16, and Perl 5.8.7. > > > > When I run a script that uses DBD::Oracle, it complains abo