Re: Passing SQL Plus command line parameter to Anonymous Procedures

On Sat, 04 May 2002 00:31:17 -0500, don hall <dchall_at_wt.net> wrote:

>declare
>
>vparm1 varchar2(20) := parm1 -- initalize a variable with the
>parameter from command line
>vparm2 varchar2(20) := parm2 -- initalize a variable with the
>parameter from command line
>--
>begin
>
>dbms_output.put_line('First paramater is '||vparm1);
>dbms_output.put_line('Second paramater is '||vparm2);
>
>end;

declare
>

vparm1 varchar2(20) := '&1' -- initalize a variable with the parameter from command line
vparm2 varchar2(20) := '&2' -- initalize a variable with the parameter from command line

--
begin


>

dbms_output.put_line('First paramater is '|:|vparm1);
dbms_output.put_line('Second paramater is '|:|vparm2);


>

end;


Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address