jernigam_at_kochind.com wrote in
news:1108738318.580729.233440_at_o13g2000cwo.googlegroups.com:
> We use a procedure that takes the stored procedure call as a parameter,
> and then an array of objects for the parameters. It looks something
> like this.
>
> public ResultSet executeCall(String sCall, Object[] params) throws
> SQLException
> {
> int iParamOffset = 2;
> CallableStatement call = conn.prepareCall(sCall);
> call.registerOutParameter(1, OracleTypes.CURSOR);
> for (int i = 0;i<params.length;i++)
> {
> call = updateCallParam(call, i+iParamOffset, params[i]);
> }
> call.execute();
> ResultSet rset = (ResultSet)call.getObject(1);
> call.close();
> return rset;
> }
>
>
and your question is ?????????????????////
Received on Fri Feb 18 2005 - 09:01:21 CST
