Sorry for the late reply, but I'm only scanning my inbox now.
On Wed, 18 Jul 2007 17:35:51 +0800, hu.darren wrote:
>my $csr = $dbh->prepare(q{
> BEGIN
> :whoami := PLSQL_EXAMPLE_DARREN.FUNC_NP;
> END;
> });
>but I failed with:
>Can't bind unknown placeholder ':whoami' at /home/darren/perl/dbitest.pl
>line 90.
>Any suggestions?
It's not an ODBC problem. You didn't declare the bind parameter in
Oracle. This would fail in SQL*plus too. Try
$dbh->prepare(q{
variable whoami varchar2(40);
});
first. (untested)
--
Bart.
