develooper Front page | perl.dbi.users | Postings from March 2012

Re: Error I've not seen before from oracle DBD

Thread Previous | Thread Next
From:
Rudolf Lippan
Date:
March 29, 2012 20:21
Subject:
Re: Error I've not seen before from oracle DBD
Message ID:
201203292319.06559.rlippan@remotelinux.com
On Thursday, March 29, 2012 at 04:46:35 PM, Bruce Johnson wrote:
> Can't mix placeholder styles (:foo/?) at /usr/local/lib64/perl5/DBD/Oracle.pm line 329., referer: https://resource-scheduler.pharmacy.arizona.edu/calendar/reserve.pl
> 
> I thought this is the code fragment producing this error:
> 

[snip]
> 
> Also, the line number in the error is from Oracle.pm, how do I find out what line in my program caused this?
> 

DBI->trace(9) is your friend for all things debugging.

Is this new code or something that is acting differently?

Also, you might save a little typing by passing  {RaiseError=>1} to connect :-)


I just looked at the code again,  and I suspect that :1...:n is being
translated into '?' placeholders internally, which would give you the mixed
placeholders :1 :2 :name.


-r

Thread Previous | Thread Next


nntp.perl.org: Perl Programming lists via nntp and http.
Comments to Ask Bjørn Hansen at ask@perl.org | Group listing | About