Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Resultset returned by stored proc not forward only

 
Nicolas DEBEAUPTE
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 276
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
see here
 
Nicolas DEBEAUPTE
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 276
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic