Re: undefined number of parameters

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Tue, 23 Mar 2004 13:14:41 -0800
Message-ID: <1080076458.5930@yasure>

Connor McDonald wrote:

> 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

I like that.

-- 
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)

Received on Tue Mar 23 2004 - 15:14:41 CST