Posted By:
jon_lee
Posted On:
Sunday, April 22, 2001 06:52 PM
Use 'registerOutParameter' method. Refer to below sample code. --- good luck ---
...
CallableStatement call = con.prepareCall( "{call sp_cursoropen (?,?,?,?,?)}");
call.registerOutParameter(1, Types.INTEGER);
call.setString(2, "select * from test_table");
call.setInt(3, 8);
call.setInt(4, 4);
call.registerOutParameter(5, Types.INTEGER);
call.executeQuery();
int id = call.getInt(1);
int size = ((Integer)call.getObject(5)).intValue();
//System.out.println(call.getObject
(5).getClass().getName());
System.out.println("cursor name: " + id);
System.out.println("total row count:" + size);
...
