Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> passing a cursor to a stored procedure from Java
Hello all,
how can I pass a cursor as an in/out-parameter to a procedure from Java?
I tried the following but it didn't work.
When I call the procedure from commandline it works fine.
...
ResultSet refcur = null;
CallableStatement statement = conn.prepareCall("{ ? = call sp_CustomerVerify
(?,?)}");
statement.registerOutParameter(1, OracleTypes.CURSOR); statement.setObject(2, refcur); statement.setString(3, custno); statement.execute();
Michael Received on Thu Jul 22 1999 - 09:45:17 CDT
![]() |
![]() |