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
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
 
 
subject: Multiple result sets possible with Oracle?