Re: undefined number of parameters

my interpretation of the quesiton was that he has no idea how many parameters he will ever need. dynamic pl/sql is the only way to go and as I said, its probably not scalable.

maybe I misinterpreted the question?

"Mark C. Stock" <mcstockX_at_Xenquery .com> wrote in message news:<gIidnckDeri-LMLdRVn-ig_at_comcast.com>...
> "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 Thu Mar 25 2004 - 06:45:26 CST