Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> passing a cursor to a stored procedure from Java

passing a cursor to a stored procedure from Java

From: Michael Waelde <mwaelde_at_intershop.de>
Date: Thu, 22 Jul 1999 16:45:17 +0200
Message-ID: <7n7apt$fjp@linux1.netconx.de>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US