Re: Named binds in Perl DBI

Am I correct in my assumption that the new, adjusted for 10g, version of Sparky
is about to appear?


On 02/26/2004 10:30:20 AM, Cary Millsap wrote:
> Thanks, Mladen. I was trying to force it to work with the values
> specified in the execute() call. I see now why that wouldn't work... The
> quoted string you're using below is just a non-numeric hash key, and
> from looking at the Oracle trace file, it appears that execute() expects
> the keys to be called ":p1", ":p2", ...
> 
> 
> Cary Millsap
> Hotsos Enterprises, Ltd.
> http://www.hotsos.com
> * Nullius in verba *
> 
> Upcoming events:
> - Performance Diagnosis 101: 2/24 San Diego, 3/23 Park City, 4/6 Seattle
> - Hotsos Symposium 2004: March 7-10 Dallas
> - Visit www.hotsos.com for schedule details...
> 
> 
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mladen Gogala
> Sent: Thursday, February 26, 2004 6:22 AM
> To: oracle-l@xxxxxxxxxxxxx
> Subject: Re: Named binds in Perl DBI
> 
> inout bind, for procedures:
> ---------------------------
> $sth->bind_param_inout( ":NUM",  \$num_drawn, 10 );
> $sth->bind_param_inout( ":DATE", \$when,      10 );
> (10 is size)
> 
> Classic bind:
> -------------
> $sth->bind_param( ":JB", $job )
> 
> 
> 
> 
> 
> 
> 
> 
> On 02/26/2004 01:20:32 AM, Cary Millsap wrote:
> > Can someone please remind me how to use the "where col1=:a" DBI syntax
> > instead of having to use "where col1=?"
> > 
> >  
> > 
> > .Can't find it.
> > 
> >  
> > 
> > Cary Millsap
> > Hotsos Enterprises, Ltd.
> > http://www.hotsos.com
> > Nullius in verba
> > 
> > Upcoming events:
> > - Performance <http://www.hotsos.com/training/PD101.html>  Diagnosis
> > 101: 2/24 San Diego, 3/23 Park City, 4/6 Seattle
> > - Hotsos Symposium 2004 <http://www.hotsos.com/events/symposium/2004>
> :
> > March 7-10 Dallas
> > - Visit www.hotsos.com for schedule details...
> > 
> >  
> > 
> > 
> 
> -- 
> Mladen Gogala
> Oracle DBA
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
> 
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
> 
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: