multiple result sets from a procedure??

[Quoted] I have seen and tried example code from these news groups that allow a PL/SQL function to return a ref cursor to JAVA, and a PL/SQL function return a result set to JAVA. Now, here's another question.... Can a procedure or function return multiple result sets or ref cursors? I now work at a company that loves Sybase and I am trying to convince them that Oracle is better. They use Sybase stored procedures and claim (which I believe) that both procedures and functions can return multiple result sets to the calling code. Any way to simulate this in Oracle?

Carl
cmercer_at_vibrant-1.com Received on Mon Jul 09 2001 - 16:41:26 CEST