Steve,
I believe the answers are yes and yes --
I do lots of stuff like this ---
my $sites_count_sth = $dbh->prepare( q(
BEGIN
getsitescount( :cnid, :sitecount, :pubsitecount );
END;
));
$sites_count_sth->bind_param(":cnid", $cnid);
$sites_count_sth->bind_param_inout(":sitecount", \$site_count, 0 );
$sites_count_sth->bind_param_inout(":pubsitecount", \$pub_site_count,
1);
$sites_count_sth->execute;
$sites_count_sth->fetchrow_array;
----
and I've used ?, :1 and named bind variables like above with DBD::Oracle. I
think I read that there are some portability issues if you use the named
variables -- '?' is supposed to be more portable if you ever switch
databases.
Will
----- Original Message -----
From: "Steve Sapovits" <[EMAIL PROTECTED]>
To: "DBI List (E-mail)" <[EMAIL PROTECTED]>
Sent: Wednesday, May 09, 2001 1:01 PM
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.
>
> ----
> Steve Sapovits
> Global Sports Interactive
> Work Email: [EMAIL PROTECTED]
> Home Email: [EMAIL PROTECTED]
> Work Phone: 610-491-7087
> Cell: 610-574-7706
> Pager: 877-239-4003
>
