I'm trying to execute an Oracle stored procedure from Perl using DBI using DBIx::ProcedureCall and I'm encountering this error.
I've successfully run my procedure from SQL Developer. Is it OK to use this module and try with other module..
---------- Perl ----------
DBD::Oracle::st execute failed: ORA-06550: line 1, column 14:
PLS-00222: no function with name 'ABC' exists in this scope
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored (DBD ERROR: error possibly near <*> indicato
+r at char 13 in 'begin :p1 := <*>abc; end;') [for Statement "begin ?
+:= abc; end;" with ParamValues: :p1=undef] at C:/Perl/site/lib/DBIx/P
+rocedureCall/Oracle.pm line 152, <CONFIG> line 78.
Output completed (2 sec consumed) - Normal Termination
Can any body guide of how should I fix this problem or use any module to execute my stored procedures..