How do i call a stored procedure with multiple outputs?
380279Jan 18 2006 — edited Jul 10 2007Hi!
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