File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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 Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Multiple result sets possible with Oracle?" Watch "Multiple result sets possible with Oracle?" New topic

Multiple result sets possible with Oracle?

Dwayne King

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?

Consider Paul's rocket mass heater.
subject: Multiple result sets possible with Oracle?
Similar Threads
getting ResultSet from Java Stored Procedure
Oracle 8I Java Stored Procedures returning a result Set
SQL Procedures
Collection as a parameter in a Callable Statement
IBM 484 : Stmt.execute(Str) - multiple result sets?