aspose file tools*
The moose likes JDBC 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 EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "OracleCallable Statement" Watch "OracleCallable Statement" New topic
Author

OracleCallable Statement

Kazeem Akinrinde
Greenhorn

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

Kazeem
Shailesh Chandra
Ranch Hand

Joined: Aug 13, 2004
Posts: 1081

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


Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: OracleCallable Statement
 
Similar Threads
URGENT - NEED HELP - Block Code
WA #1.....word association
Can the color for the disabled item be changed
error in Marcus Green 2.
Private methods