Re: Pass as many parameters as I can

From: Lee J. <ljeznach_at_csi.com>
Date: Thu, 21 Dec 2000 20:01:49 GMT
Message-ID: <Nkt06.125333$_5.28283285@news4.rdc1.on.home.com>

I don't have too much experience with oracle but your question seems to be of programming type.
As a programmer, I would use VARCHAR2 type of parameter and I would pass as many info within one varchar2 parameter as it allows - you can used larger data type if you wish.
Then you extract all info form the string passed to your procedure. Could be stored in an array - it depends what you plan to do.

overloading or not requires hard coding and you will have to stick to a certain number of paramiters.

<chiayen_at_my-deja.com> wrote in message news:91slv5$qtd$1_at_nnrp1.deja.com...
> How to create a stored procedure/ function that
> can accept any numbers of parameters?
>
>
> eg p_abc('a', 'b') and p_abc('a', 'b', 'c')....
> will call the same procedure.
>
> Thanks
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Thu Dec 21 2000 - 14:01:49 CST