On Sat, 31 Aug 2002 11:28:23 +0200 Hallvard B Furuseth <[EMAIL PROTECTED]>
wrote:
Something I noticed after I sent my last.
> my $sel = $dbh->prepare("
> BEGIN
> OPEN :csr FOR
> SELECT fakultetnavn FROM lt.fakultet WHERE fakultetnavn IS NOT NULL
> FOR UPDATE;
> END;");
> my $csr;
> $sel->bind_param_inout(":csr", \$csr, 0, { ora_type => ORA_RSET } );
> $sel->execute();
> my $upd = $dbh->prepare("
> UPDATE lt.fakultet SET fakultetnavn=? WHERE CURRENT OF csr");
You already know you can't mix '?' and ':csr' style placeholders. You may
also realize that :csr in $upd is not the same bind variable as :csr in
$sel, but it was not obvious to me from you message.
--
Mac :})
** I normally forward private questions to the appropriate mail list. **
Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.html
Give a hobbit a fish and he eats fish for a day.
Give a hobbit a ring and he eats fish for an age.
