• Post Reply Bookmark Topic Watch Topic
  • New Topic

Multiple result sets possible with Oracle?  RSS feed

Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!