Re: optional parameters?

From: Michel Cadot <micadot_at_netcourrier.com>
Date: 2000/07/27
Message-ID: <8loq20$1r17$1@s2.feed.news.oleane.net>#1/1

Yes, you have to give a default value to the parameter:  CREATE OR REPLACE schema.proc_name

     (
     Parm1    number,
     Parm2    varchar2,
     Parm3    number default null or default 0 or...
     )

 ...

--
Have a nice day
Michel


Me <a_at_a.com> a écrit dans le message : 1MKf5.153$Dw6.1195_at_newsfeed.slurp.net...


> Does Oracle 7.3 support optional parameter in procedures?  Something like:

>

> CREATE OR REPLACE schema.proc_name

>     (

>     Parm1    number,

>     Parm2    varchar2,

>     Parm3    number Option

>     )

> ...

>

> Thanks,

>

> Craig Buchanan

>

>

>

>

>

>

>

>

Received on Thu Jul 27 2000 - 00:00:00 CDT