• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Resultset returned by PL/SQL function

 
Nicolas DEBEAUPTE
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
We are using an Oracle Database and we have a PL/SQL function wich returns a resultSet (get back in a java code program on a callableStatement as an OracleTypes.CURSOR).
The problem is that that resultset is forward only and we have no idea how to modify the PL/SQL function or the client java code (wich call the function) to make the resultset scrollable.
Anyone having any idea and having already tried it, is welcome ...
Thanks in advance.
Nicolas DEBEAUPTE
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm not sure if Oracle supports this but this is how;

Jamie
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic