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: varargs in PL/SQL

Re: varargs in PL/SQL

From: Jim Smith <usenet01_at_ponder-stibbons.com>
Date: Sun, 25 Feb 2007 08:56:33 +0000
Message-ID: <wxiGBnbB9U4FFwKf@jimsmith.demon.co.uk>


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

Original text of this message

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