Unanswered: Calling Oracle Stored Procedure with Perl
I have been calling a number of Stored Procedures in an Informix DB with no problems, but now I need to run one against an Orcale DB - and I am having problems. And none of the examples I have online seem to help.
I am running the Perl from a Solaris Box, the Oracle DB is on a different Solaris Box. I have installed the Oracle Client and put up the TNSNames.ora file - I do not beleive I am having a connection problem.
The error I get is:
Can't call method "prepare" without a package or object reference at ./sp_FTD_GetNextProc.pl line 40.
The perl code is:
$sth = $dbh2->do("BEGIN SP_FTD_GETNEXTPROC; END;");