SQL & PL/SQL

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!

Return multiple cursors from one procedure

565985Jul 12 2007 — edited Jul 13 2007

Hi,

I have a stored procedure that is suposed to return multiple records. I know that for each table that I return I have to add a param to the stored procedure, param with ref cursor type.

I do not know exactly how many tables I have to return, it depends on data from some tables.

Is it possible to return an unknown number of tables? like an array or something ...

Please help

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 10 2007

Added on Jul 12 2007

9 comments

7,644 views