RE: Named binds in Perl DBI

From: Pete Sharman <peter.sharman_at_oracle.com>
Date: Fri, 27 Feb 2004 04:07:21 +1100
Message-Id: <200402261706.i1QH6v228489@rgmgw6.us.oracle.com>

The answer is simple. Don't present at the less important ones, like the Hotsos Symposium. :)

Pete

"Controlling developers is like herding cats."

Kevin Loney, Oracle DBA Handbook

"Oh no, it's not. It's much harder than that!"

Bruce Pihlamae, long-term Oracle DBA

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Cary Millsap Sent: Friday, February 27, 2004 3:34 AM
To: oracle-l_at_freelists.org
Subject: RE: Named binds in Perl DBI

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mladen Gogala Sent: Thursday, February 26, 2004 10:04 AM To: oracle-l_at_freelists.org
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_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
-----------------------------------------------------------------

----------------------------------------------------------------
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 - 11:11:35 CST