Re: Optional parameter execution while executing .sql file ..
- From: Jared.Still@xxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 10 Aug 2004 11:23:13 -0700
oracle-l-bounce@xxxxxxxxxxxxx wrote on 08/10/2004 11:20:20 AM:
...
> execute dss_report_tracker.complete_report(&1,&2);
>
> as the second line is not getting the first parameter , it stops to
> key in the second one
> (asks for values)?.
>
> We want to run the program , from some places with one parameter,
> and from some other places
> with 2 parameter. Inside the procedure complete_report second
> parameter is defaulted to 'VALID'.
> So no issues there.
>
> So how to modify the line
> execute dss_report_tracker.complete_report(&1,&2);
> so as to expect the parameter 2 as optional
>
Write a wrapper in the language of choice (Perl in my case) and control
the arguments that are received from the command line.
Pass a dummy argument when there is none on the command line.
Easily done in ksh or bash as well.
Jared
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
