Re: ? about multiple parameters in an O8 procedure???

From: QuestionExchange <USENET_at_questionexchange.com>
Date: 18 Nov 1999 21:52:36 GMT
Message-ID: <2911qx@questionexchange.com>

Richard
Procedures CAN return values - via the parameters. Parameters can be IN, OUT or IN/OUT.
So - just define an OUT or IN/OUT parameter! :-) Keep in mind -

IN - CANNOT assign ANYTHING to it inside the procedure. OUT - initialize to NULL before the call as the procedure expects it to have no value until one is assigned.

IN/OUT - can have a value and the value can be changed. Enjoy!
Becca
> Hi folks.
>
> Since an Oracle procedure returns no parameters, and a
function returns
> exactly one, how do you return multiple parameters in an
Oracle program?
>
> Thanks,
>
> Richard H.
>
>

--
This answer is courtesy of QuestionExchange.com http://www.questionexchange.com/showUsenetGuest.jhtml?ans_id=8046&cus_id=USENET&qtn_id=9365 Received on Thu Nov 18 1999 - 15:52:36 CST