Re: undefined number of parameters

Daniel Morgan wrote:
>
> 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)

Or pass a collection which contains any number of parameters you like

hth
connor

-- 
-------------------------------
Connor McDonald
http://www.oracledba.co.uk
Co-Author: "Mastering Oracle PL/SQL - Practical Solutions"