aspose 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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Multiple result sets possible with Oracle?
 
Similar Threads
Oracle 8I Java Stored Procedures returning a result Set
IBM 484 : Stmt.execute(Str) - multiple result sets?
SQL Procedures
Collection as a parameter in a Callable Statement
getting ResultSet from Java Stored Procedure