Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

possible to return multiple result sets with Oracle

kridanJun 27 2002

Is it even possible to return multiple result sets with Oracle?

I am in the middle of porting a SQL Server (ack!) application 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?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 25 2002

Added on Jun 27 2002

#java-database-connectivity-jdbc

0 comments

366 views