This week's book giveaway is in the JavaFX forum.
We're giving away four copies of Introducing JavaFX 8 Programming and have Herbert Schildt on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes OracleCallable Statement Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Introducing JavaFX 8 Programming this week in the JavaFX forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "OracleCallable Statement" Watch "OracleCallable Statement" New topic

OracleCallable Statement

Kazeem Akinrinde

Joined: Aug 24, 2002
Posts: 21
Please can anybody explain how i can return a resultset from oracle stored prcedure into my java code?

Thanx in anticpation of your help

Shailesh Chandra
Ranch Hand

Joined: Aug 13, 2004
Posts: 1082

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


Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
I agree. Here's the link:
subject: OracleCallable Statement
It's not a secret anymore!