Re: How declare optional argments?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 10 Jan 2000 22:08:45 -0000
Message-ID: <947542296.7754.2.nnrp-11.9e984b29@news.demon.co.uk>

Give them default values:

create or replace procedure XXX (

i_1 in number,
i_2 in number default null
);

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Robert R. Wagner wrote in message ...
>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:08:45 CST