Hi,
I am trying to execute the stored procedure using dbh. The procedure details
are as follows:
proc_dequeue( BALID,strRequestXML,strStatus)
where:
BALID - Integer,
strRequestXML - XMLType,
strStatus - varchar
The perl script implemented is :
my $sth = $dbh1->prepare("begin proc_dequeue(:BALID,:strRequestXML,:strStatus);
end;");
$sth->bind_param_inout(":BALID",\$o_balid,20,\%attr );
$sth->bind_param_inout(":strRequestXML",\$o_requestXML,50000,\%attr);
$sth->bind_param_inout(":strStatus",\$o_status,2,\%attr);
and the error message i am getting is :
DBD::Oracle::st execute failed: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'proc_dequeue'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored (DBD ERROR: OCIStmtExecute) at ./ListenerBalA line 32.
DBD::Oracle::st execute failed: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'proc_dequeue'
Please help me to resolve this problem.
Thanks in advance.
Regards,
Sumitra
============================================================================================================================
Tech Mahindra, formerly Mahindra-British Telecom.
Disclaimer:
This message and the information contained herein is proprietary and
confidential and subject to the Tech Mahindra policy statement, you may review
at <a
href="http://www.techmahindra.com/Disclaimer.html";>http://www.techmahindra.com/Disclaimer.html</a>
externally and <a
href="http://tim.techmahindra.com/Disclaimer.html";>http://tim.techmahindra.com/Disclaimer.html</a>
internally within Tech Mahindra.
============================================================================================================================
