Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Named binds in Perl DBI

RE: Named binds in Perl DBI

From: Cary Millsap <cary.millsap_at_hotsos.com>
Date: Thu, 26 Feb 2004 10:34:27 -0600
Message-ID: <003c01c3fc86$66ff2400$d06a8640@CVMLAP02>


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
-----------------------------------------------------------------
Received on Thu Feb 26 2004 - 10:41:05 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US