• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Jeanne Boyarsky
  • Ron McLeod
Sheriffs:
  • Paul Clapham
  • Liutauras Vilda
  • Devaka Cooray
Saloon Keepers:
  • Tim Holloway
  • Roland Mueller
Bartenders:

Resultset returned by stored proc not forward only

 
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Ranch Hand
Posts: 276
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
see here
 
Nicolas DEBEAUPTE
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
There are 29 Knuts in one Sickle, and 17 Sickles make up a Galleon. 42 tiny ads in a knut:
Smokeless wood heat with a rocket mass heater
https://woodheat.net
reply
    Bookmark Topic Watch Topic
  • New Topic