'?' placeholders get converted into ':1' style placeholders inside
DBD::Oracle, so there should be no reason that they wouldn't work. The
examples in DBD-Oracle-1.06/Oracle.ex/ use named placeholders like ':value'
because they are easier to keep straight, but they are not required.
The statement handles in examples 2, 3, and 4 in Oracle.ex/proc.pl may be
executed() as many times as you like after they are prepare()d.
--
Mac :})
** I normally forward private database questions to the DBI mail lists. **
Give a hobbit a fish and he'll eat fish for a day.
Give a hobbit a ring and he'll eat fish for an age.
----- Original Message -----
From: "Steve Sapovits" <[EMAIL PROTECTED]>
To: "DBI List (E-mail)" <[EMAIL PROTECTED]>
Sent: Wednesday, May 09, 2001 13:01
Subject: Oracle stored procedures
> I thought I read this in docs somewhere but can't find it:
>
> Can Oracle SP's be prepared once and executed multiple times
> using placeholder values? And, is '?' acceptable as a
> placeholder?
>
> The SP examples I have are all prepare once/execute once and
> all use the :1 placeholder syntax.
