Re: undefined number of parameters

laly wrote:

> Hello,
>
>
> Is it possible to develop a PL/SQL function having a variable number
> of parameters to implement in Oracle 8i, Oracle 9i's coalesce like
> function ?
>
>
> Thanks in advance,
>
> Laly.

Yes. The technique is called overloading and can be found in two different types of Oracle objects: Packages and Operators. You can find examples at:

http://www.psoug.org/reference/packages.html http://www.psoug.org/reference/operator.html

<reference to another thread>
Is this an example of us keeping our knowledge guarded? ;-) </reference to another thread>

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)