This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
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?
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
subject: Multiple result sets possible with Oracle?