Re: Pass as many parameters as I can

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 21 Dec 2000 12:03:20 +0100
Message-ID: <91sq06$58jbb$2@ID-62141.news.dfncis.de>

Add default clauses to the optional parameters like this

create or replace procedure foo(p_1 in number, p_2 in number default 0) etc.

This is a procedure with one mandatory and one optional parameter.

Hth,

Sybrand Bakker, Oracle DBA

<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 - 05:03:20 CST