Execute Oracle Stored procedure using DBIx::ProcedureCall

kalyanrajsista has asked for the wisdom of the Perl Monks concerning the following question:

I'm trying to execute an Oracle stored procedure from Perl using DBI using DBIx::ProcedureCall and I'm encountering this error.

More Info::

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
[download]

Can any body guide of how should I fix this problem or use any module to execute my stored procedures..

Back to Seekers of Perl Wisdom