aspose file tools*
The moose likes JDBC and the fly likes Resultset returned by stored proc not forward only Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Resultset returned by stored proc not forward only" Watch "Resultset returned by stored proc not forward only" New topic
Author

Resultset returned by stored proc not forward only

Nicolas DEBEAUPTE
Greenhorn

Joined: Jul 19, 2001
Posts: 4
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
Daniel Dunleavy
Ranch Hand

Joined: Mar 13, 2001
Posts: 276
see here
Nicolas DEBEAUPTE
Greenhorn

Joined: Jul 19, 2001
Posts: 4
Daniel, thanks for your help first,

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
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
 
 
subject: Resultset returned by stored proc not forward only