RE: Named binds in Perl DBI

From: Cary Millsap <cary.millsap_at_hotsos.com>
Date: Thu, 26 Feb 2004 09:30:20 -0600
Message-ID: <000a01c3fc7d$7222f130$d06a8640@CVMLAP02>

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
-----------------------------------------------------------------

Received on Thu Feb 26 2004 - 09:38:23 CST