Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Facing problem with CallableStatement
suresht.rsl_at_gmail.com wrote:
> 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.
Reread the error message carefully. Then reread your code. It's all in there.
robert Received on Mon May 08 2006 - 10:30:02 CDT