File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes How to create Multiple Resultset in oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How to create Multiple Resultset in oracle" Watch "How to create Multiple Resultset in oracle" New topic
Author

How to create Multiple Resultset in oracle

Rajendra Prakash
Ranch Hand

Joined: Sep 10, 2009
Posts: 293
How to create multiple resultset normally and how to create ResultSet in Stored procedure.
Should i create temporary tables. if so how to create that.
Nigel Ren
Greenhorn

Joined: Oct 12, 2010
Posts: 1
You can return a cursor from a stored procedure, which allows you to return a full set of rows in a single row of your Java result set.
I found the following resource which gives you a worked example : http://www.oracle-base.com/articles/misc/UsingRefCursorsToReturnRecordsets.php

Nigel
Rajendra Prakash
Ranch Hand

Joined: Sep 10, 2009
Posts: 293
Cursor ok. can we create multiple resultset normally and also how to create multiple resultset
in stored procedure
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to create Multiple Resultset in oracle