Re: undefined number of parameters

"Ryan Gaffuri" <rgaffuri_at_cox.net> wrote in message news:1efdad5b.0403220943.7d3735fa_at_posting.google.com...
| you will have to build it on the fly with dynamic pl/sql(wrap it in
| execute immediate).
|
| this will not scale well since it will need to be recompiled each time
| its executed.
|

not exactly .... there is no such need

overloading (as daniel mentioned) is a partial answer... i still don't think oracle allows an infinitely variable number of parameters (like good old argv and argc) but you can define as many variations of an overloaded function as you like -- they just each need to be explicitly defined; but there certainly is no need for dynamic pl/sql and no scaling problem

;-{ mcs

| laly.kattoor_at_bnpparibas.com (laly) wrote in message
news:<ef64358b.0403212346.2209c168_at_posting.google.com>...
| > 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.
Received on Mon Mar 22 2004 - 21:37:41 CST