How can I create an Oracle stored procedure which return a ResultSet , so I can retrieve the ResultSet in
Java like this:
CallableStatement cs = conn.prepareCall("{call PROC_XXX(?, ?)}");
cs.setInt(1, 25);// this is a parameter pass in as some condition
cs.registerOutParameter(2, java.sql.Types.OTHER);// this is the OUT parameter which will return as a ResultSet
cs.execute();
ResultSet rset = (ResultSet)cs.getObject(2);
//....Now I can go through the 'rset' ...
...
Will be very appreciated if any one can give out a sample, thanks advance !