Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

OracleCallable Statement

 
Kazeem Akinrinde
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Please can anybody explain how i can return a resultset from oracle stored prcedure into my java code?

Thanx in anticpation of your help

Kazeem
 
Shailesh Chandra
Ranch Hand
Posts: 1082
Java Oracle Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
1. Create a Stored Procedure which returns cursor.
2. Register the out paramter as cursor



3. retrieve the out parameter as object



4 Process your ResulSet as whatever you want.

hope this helps

Shailesh
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic