Hi:
I'm trying (and failing) to use a stored PL/SQL function from a perl/DBI script.
Here's an excerpt....
$qrystr = "select myplsqlfunc(param1, param2) from dual;
$sth = $dbh->prepare($qrystr)
or die "Failed to prep statement--- $qrystr";
$sth->execute()
or die "Failed to execute statement... $qrystr";
The error I get is...
DBD::Oracle::db prepare failed: ORA-00904: invalid column name (DBD ERROR:
OCIStmtExecute/Describe) at try_stored.pl 10.
The statement works fine using the character cell SQL interface to the Oracle DB. The
statement in perl runs fine if I change the query to access some other table/column in
the DB (no function calls).
Has anyone been able to get this sirt of thing to work?
Oracle 8i release 8.1.7.0.0 served from a 64 bit alpha running Tru64.
Query from a Linux client, through Oracle OCI, using perl
($PERL_VERSION doesn't seem to be set, so I can't tell you about that)
Thanks !
