Re: varargs in PL/SQL

From: Maxim Demenko <mdemenko_at_arcor.de>
Date: Fri, 23 Feb 2007 15:42:50 +0100
Message-ID: <45DEFD6A.2070308@arcor.de>

Filipe David Borba Manana schrieb:
> 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?

There seem to be no documented way of doing this (as of 10g) , however, there are such pl sql function(s) delivered by oracle. http://download-uk.oracle.com/docs/cd/B19306_01/appdev.102/b14258/u_lms.htm#sthref14840

Best regards

Maxim Received on Fri Feb 23 2007 - 08:42:50 CST