Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Pass as many parameters as I can

Re: Pass as many parameters as I can

From: Lee J. <ljeznach_at_csi.com>
Date: Thu, 21 Dec 2000 19:39:39 GMT
Message-ID: <%%s06.125280$_5.28265566@news4.rdc1.on.home.com>

The question was "...can accept any numbers of parameters?" Read carefully before you answer any question.

"Walter T Rejuney" <BlueSax_at_Unforgetable.com> wrote in message news:3A41FE94.C2BFB2E3_at_Unforgetable.com...
> 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 - 13:39:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US