Skip to Main Content

Integration

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!

How do i call a stored procedure with multiple outputs?

380279Jan 18 2006 — edited Jul 10 2007
Hi!

I'm trying to call an oracle stored procedure with multiple outputs where one of them is a record set. Does anyone know how to do this? I have no problems calling procedures that just return a record set and theres is also not a problem to call a procedure that returns many single values.

The procedure has the following kind of signature:
procedure doSomething (
inputvariable IN NUMBER,
outputvariableOne OUT NUMBER,
outputvariableTwo OUT VARCHAR2,
outputRecordSet OUT curRecords);

Where curRecords is defined as:
TYPE curRecords IS REF CURSOR;

Regards,
Bjorn Boe
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 7 2007
Added on Jan 18 2006
5 comments
2,311 views