Resultset returned by stored proc not forward only
Nicolas DEBEAUPTE
Greenhorn
Joined: Jul 19, 2001
Posts: 4
posted
0
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) ?
Daniel Dunleavy
Ranch Hand
Joined: Mar 13, 2001
Posts: 276
posted
0
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
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to
run our stuff on 16 servers instead of 3.
subject: Resultset returned by stored proc not forward only
0
