Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • 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
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!