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

A copy of this was sent to Richard Hollingsworth <william.hollingsworth_at_hsv.boeing.com>
(if that email address didn't require changing) On Mon, 15 Nov 1999 15:54:06 GMT, you wrote:

>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.

procedures can return as many as you like:

create procedure my_proc( x in OUT varchar2 ) ...

                               ^^^

functions can also. functions have the added benefit that they can return a value as welll but other then that are the same as a procedure.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Mon Nov 15 1999 - 10:27:51 CST