Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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"Received on Tue Mar 23 2004 - 06:07:16 CST