define a default for the parameter or overload the procedure .(same name,
different # of parameters)
eg
create or replace procedure myProc( param1 in varchar2, param2 in varchar2
default 'FOO');
Jim
--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family. Remove the negative part, keep the minus sign. You can figure
it out.
"bart" <bart_at_projectbeta.org> wrote in message
news:ncKU9.10971$ym5.1581_at_afrodite.telenet-ops.be...
> hellow,
>
> How can I create a pl/sql procedure with optional parameters?
>
> so I can call the procedure without passing all the values?
>
> thx
>
>
Received on Mon Jan 13 2003 - 21:16:02 CST
