calling oracle stored proc from java

[redsss]

I am calling an Oracle stored procedure from java and need to retrieve the numeric value returned as an OUT parameter..

PROCEDURE myproc (n_retval OUT NUMBER)

I'm trying something like this. What am I missing?

cstmt = gps.prepareCall("{ call myproc(?)}");
cstmt.registerOutParameter(1, OracleTypes.NUMBER);
cstmt.execute();

int n_ret = (int)oracle.sql.NUMBER(cstmt.getObject(1));

 

[sedj]

I would have the last line like :

int ret = cstmt.getInt(1);

What errors are you seeing ?

 

[redsss]

thanks!