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@xxxxxxxxxxxxxxxx
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
.