Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL variable argument list function

Re: PL/SQL variable argument list function

From: Marcus Neppl <Marcus.Neppl_at_klinik.uni-regensburg.de>
Date: Fri, 03 Jul 1998 16:44:34 +0200
Message-ID: <359CEE52.8F6E98D7@klinik.uni-regensburg.de>


You have to overload your procedure. It's like C. Different types and different number of parameters. See PL/SQL User's Guide and Reference (My Version is V2.0!) page 7-14,ff and page 6-18, ff

Nuno Guerreiro wrote:

> Is it possible to create a function/procedure in PL/SQL with a
> variable number of arguments (as in C)?
>
> If the decode() function was written in standard PL/SQL, then it
> should be possible, right?
>
> I don't see any reference to this in the Oracle documentation.
>
> Thanks for any help,
>
> Nuno Guerreiro
Received on Fri Jul 03 1998 - 09:44:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US