RE: Named binds in Perl DBI
- From: "Cary Millsap" <cary.millsap@xxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 26 Feb 2004 10:34:27 -0600
Negative. Sorry about that. It's just me trying to keep up with my
obligation to write presentations for all the blinkin' conferences I'm
signed up to present for. That leaves little room in my schedule for
maintaining software that we give away.
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 10:04 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: 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 //www.freelists.org/archives/oracle-l/
> FAQ is at //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 //www.freelists.org/archives/oracle-l/
> FAQ is at //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 //www.freelists.org/archives/oracle-l/
FAQ is at //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 //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
