This is not a DBI or a perl issue. Read your error stack and resolve your Oracle issue.
-- Ron Reidy Lead DBA Array BioPharma, Inc. -----Original Message----- From: Sumitra Gatade [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 07, 2006 6:01 AM To: dbi-users@perl.org Subject: DBI - error 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.techmahind ra.com/Disclaimer.html</a> externally and <a href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahind ra.com/Disclaimer.html</a> internally within Tech Mahindra. ======================================================================== ==================================================== This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system.