Can I call CallableStatement .getObject(int)

[Lasse Koskela]

I caught an "SQLException: Invalid column index" from the following code and was wondering whether someone would know can I call CallableStatement.getObject(int) in the first place? (the javadocs don't say anything about not being allowed to call that)

CallableStatement cs = connection.prepareCall("{call myproc(?,?,?,...)}"); // the stored procedure has over 20 parameters
cs.setString(1, "foobar");
...
Object value = cs.getObject(1); // throws the exception

The stack trace looks like this:

java.sql.SQLException: Invalid column index
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:285)
        at oracle.jdbc.driver.OracleStatement.prepare_for_new_get(OracleStatement.java:2797)
        at oracle.jdbc.driver.OracleStatement.getObjectValue(OracleStatement.java:4858)
        at oracle.jdbc.driver.OracleStatement.getObjectValue(OracleStatement.java:4839)
        at oracle.jdbc.driver.OracleCallableStatement.getObject(OracleCallableStatement.java:585)
        at weblogic.jdbc.pool.Statement.getObject(Statement.java:745)
        at weblogic.jdbc.rmi.internal.CallableStatementImpl.getObject(CallableStatementImpl.java:184)
        at weblogic.jdbc.rmi.SerialCallableStatement.getObject(SerialCallableStatement.java:291)

Have I understood the meaning of CallableStatement.getObject(int) wrong? Is it supposed to return the parameter set with the corresponding setXXX(int) method or is it supposed to return one of the return values of the stored procedure? If it's the latter, then is there any other way of getting the parameters out of the CallableStatement once they've been set?

[SJ Adnams]

you need to do a registerOutputParameter() first. Post the header of your pl/sql proceedure if that doesn't work (I imagine in/out might be the problem if you already do that).
Simon

[Lasse Koskela]

Thanks Simon. Unfortunately I can't use the registerOutParameter(...) method so I'll have to resort to some other means...