Re: undefined number of parameters

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Tue, 23 Mar 2004 07:50:44 -0500
Message-ID: <zcmdnS9Mzqtfr_3dRVn-jg@comcast.com>

"Connor McDonald" <hamcdc_at_yahoo.co.uk> wrote in message news:40602874.4225_at_yahoo.co.uk...
| 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
| --

• which is what the PL/SQL gateway does with its 'Flexible Parameter Passing' approach

;-{ mcs Received on Tue Mar 23 2004 - 06:50:44 CST