Re: undefined number of parameters

From: Ryan Gaffuri <rgaffuri_at_cox.net>
Date: 22 Mar 2004 09:43:47 -0800
Message-ID: <1efdad5b.0403220943.7d3735fa@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.

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 - 11:43:47 CST