Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: varargs in PL/SQL
Filipe David Borba Manana wrote:
> Is there any way to create a function/procedure in PL/SQL with a
> variable arguments lists?
>
> I want to create a procedure which may be called with 1, 2, 3... or any
> number of parameters, say, something like the printf family of functions
> in C.
>
> Anyway to do it?
Look at overloading the function or procedure within a package. That is how Oracle does things.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Fri Feb 23 2007 - 11:08:33 CST