File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
Joined: Aug 24, 2002
Feb 01, 2005 04:22:00
Please can anybody explain how i can return a resultset from oracle stored prcedure into my
Thanx in anticpation of your help
Joined: Aug 13, 2004
Feb 01, 2005 04:56:00
1. Create a Stored Procedure which returns cursor.
2. Register the out paramter as cursor
3. retrieve the out parameter as object
ResultSet rs = (ResultSet) callablestmt.getObject(1);
4 Process your ResulSet as whatever you want.
hope this helps
Gravitation cannot be held responsible for people falling in love ~
I agree. Here's the link:
subject: OracleCallable Statement
Disadvantage of Java Business Developmet over Stored prcedures
hibernate annotations for stored prcedure in pojo class
Most Effective way of configuring many datasources in JBoss
Getting classcast exception when getting cursor from stored prcedure
Converting String to Clob
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015