Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: varargs in PL/SQL
In message <ermr7l$ont$1_at_cernne03.cern.ch>, Filipe David Borba Manana
<fdmanana_at_cern.ch> writes
>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?
Probably the only practical way to do it is to use a collection type as
a parameter.
-- Jim Smith Ponder Stibbons Limited <http://oracleandting.blogspot.com/> RSS <http://oracleandting.blogspot.com/atom.xml>Received on Sun Feb 25 2007 - 02:56:33 CST