Facing problem with CallableStatement

From: <suresht.rsl_at_gmail.com>
Date: 8 May 2006 07:46:19 -0700
Message-ID: <1147096417.851787.278970@y43g2000cwc.googlegroups.com>

Hi All,
i have a stored procedure like this......

CREATE OR REPLACE package pkg_eqp_typ_tree as  type pepc_partial_qual_nmTab is table of varchar2(60) index by binary_integer;
procedure stp_eqp_typ_tree (
 batch_size in smallint,
 pepc_partial_qual_nm_tab out pepc_partial_qual_nmTab, ); end pkg_eqp_typ_tree; /

my java code is

---

String sql = "{call pkg_eqp_typ_tree.stp_eqp_typ_tree (?,?)}"; OracleCallableStatement cstmt =
(OracleCallableStatement)con.prepareCall(sql);

cstmt.setShort(1,(short)100);
cstmt.registerOutParameter(2, Types.VARCHAR);
cstmt.execute();

while compiling the code iam getting error "PLS-00306: wrong number or types of arguments in call to 'STP_EQP_TYP_TREE'" can any one help me.

Thanks in advance.

Thanks & Regards,
Suresh T. Received on Mon May 08 2006 - 09:46:19 CDT