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_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mladen Gogala
> Sent: Thursday, February 26, 2004 6:22 AM
> To: oracle-l_at_freelists.org
> 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_at_freelists.org
> 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_at_freelists.org
> 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_at_freelists.org
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
-----------------------------------------------------------------
Received on Thu Feb 26 2004 - 10:14:49 CST
