Re: Newbie odbc/oracle-procedure-questions

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;