Getting Recordsets from Stored Procedure [Archive]

View Full Version : Getting Recordsets from Stored Procedure

austrian_ead

02-04-03, 07:52

Hi Folks,

How do I access Recordsets in Java from an Oracle STored Procedure.

I know that I can return a recordset from a stored procedure in oracle through an output parameter, that contains a cursor. But how can I access that cursor in Java?

deenig2

02-14-03, 11:07

Here are the logical / code steps.

import oracle.sql.*;
import oracle.jdbc.driver.*;
.....

cstmt = conn.prepareCall("procedureName");
//Assumiing Dates 2 parameters,
cstmt.setDate(1, p1Date);
cstmt.setDate(2, p2Date);
// Third Parameter is Cursor
cstmt.registerOutParameter(3, OracleTypes.CURSOR);
cstmt.execute();

rs = (ResultSet) ((OracleCallableStatement)cstmt).getObject(3);