Re: Defaulting the parameters in a sqlplus script.

On 19 May 2004 08:43:10 -0500, Galen Boyer <galenboyer_at_hotpop.com> wrote:

> Is this possible, so that you don't have to pass all parameters at
> the command-line? I'm on 9i if there are any later features for
> this.
>

just use the default option, e.g:

create or replace procedure default_test (moo in varchar2 default 'toot')
is
begin
dbms_output.put_line(moo);
end;
/

-- 
If we can't play God, who will?