Re: How declare optional argments?

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Mon, 10 Jan 2000 23:07:16 +0100
Message-ID: <947542131.9341.0.pluto.d4ee154e@news.demon.nl>

procedure xyz(par1 in number, par2 in number, par3 in number default 0) Of course
xyz(5,6)
will cause 0 to be assigned to par3
I'm not sure what happens if you use
xyz(par2=>6,par1=>5)
Anyhow you can't mix positional and non-positional syntax.

Hth,

--
Sybrand Bakker, Oracle DBA
Robert R. Wagner <expantes_at_maine.rr.com> wrote in message news:dBse4.5908$Wu6.118549_at_newsr1.maine.rr.com...
> I have about 6 good books on Oracle, but none of them tell me how to
declare
> optional input parameters in procedures and functions. I suppose that
either
> it's terribly obvious, or it's impossible (without using overloading).
>
> What't the scoop on this?
>
> TIA >>>>>> Robert
> ExpanTest, Inc.
> 22 Monument Square, Suite 503
> Portland, ME 04101-4031
> http://www.gwi.net/expantest
> (207) 871-0224
>
Received on Mon Jan 10 2000 - 16:07:16 CST