File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
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