Resultset returned by stored proc not forward only
Joined: Jul 19, 2001
Hi, We access data in an ORACLE base using jdbc. By default, it seems that a resultset returned as a parameter of a stored procedure or function is forward_only so that you can't scroll forward or backward in that resultset. How to get from a stored proc a result set which is NOT forward only ? thanks for help Nicolas
But, the problem is not to create via JDBC a scrollable resultset but rather to scroll through a resultset returned by a stored procedure (type OracleTypes.CURSOR for an oracle database). In this case, you get the resultset directly (not by creating a PreparedStatement or CallableStatement and passing to it the right parameters to get scrollable resultset). So my question was how toget a scollable result when calling a stored procedure in oracle (PL/SQL) which return a resultset (CURSOR) ?
Joined: Mar 13, 2001
Well, if you don't want to do the other select...order by other_col....then I guess you could store the objects and use the sort Dan