<?xml version="1.0" encoding="windows-1252"?>
<node id="813695" title="Execute Oracle Stored procedure using DBIx::ProcedureCall" created="2009-12-21 08:02:52" updated="2009-12-21 08:02:52">
<type id="115">
perlquestion</type>
<author id="627193">
kalyanrajsista</author>
<data>
<field name="doctext">
&lt;P&gt;
I'm trying to execute an Oracle stored procedure from Perl using DBI using DBIx::ProcedureCall and I'm encountering this error.&lt;/P&gt; 

&lt;P&gt;More Info::&lt;/P&gt;
&lt;P&gt;I've successfully run my procedure from SQL Developer. Is it OK to use this module and try with other module..&lt;/P&gt;


&lt;code&gt;
---------- 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 &lt;*&gt; indicator at char 13 in 'begin :p1 := &lt;*&gt;abc; end;') [for Statement "begin ? := abc; end;" with ParamValues: :p1=undef] at C:/Perl/site/lib/DBIx/ProcedureCall/Oracle.pm line 152, &lt;CONFIG&gt; line 78.

Output completed (2 sec consumed) - Normal Termination
&lt;/code&gt;

&lt;P&gt; Can any body guide of how should I fix this problem or use any module to execute my stored procedures..&lt;/P&gt;</field>
</data>
</node>
