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 Multiple result sets possible with Oracle? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Multiple result sets possible with Oracle?" Watch "Multiple result sets possible with Oracle?" New topic
Author

Multiple result sets possible with Oracle?

Dwayne King
Greenhorn

Joined: May 30, 2002
Posts: 7
Is it even possible to return multiple result sets with Oracle?
I am in the middle of porting a SQL Server app to Oracle, and there are several stored procedures that return multiple result sets. I don't know how the heck this would translate to PL/SQL unless I have an OUT parameter for each resultset. I would rather not do that though, since then the signature of the stored proc would be different for each database.
Ideas anyone? Is getMoreResults() even implemented in the Oracle JDBC driver?


DKK
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Multiple result sets possible with Oracle?