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

From: paul cluiss <paul_cluiss_at_intervoice.com>
Date: Mon, 15 Nov 1999 10:53:48 -0600
Message-ID: <A0D6FDE1A287DE72.77991DA111506954.9CC8F193A533004D@lp.airnews.net>

Who said that Oracle stored procedure return no parameters? They're just like procedures in other languages, such as C/C++, Pascal, Fortran. Just be sure to declare these parameters as OUT or IN OUT so the procedure can return values to the caller through them.

Paul Cluiss
Dallas, Texas

Richard Hollingsworth 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.
Received on Mon Nov 15 1999 - 10:53:48 CST