Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Pass as many parameters as I can
Sybrand Bakker wrote:
> 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.
It can also be accomplished by overloading. Received on Thu Dec 21 2000 - 06:59:00 CST