Passing SQL Plus command line parameter to Anonymous Procedures

From: don hall <dchall_at_wt.net>
Date: Sat, 04 May 2002 00:31:17 -0500
Message-ID: <3CD37225.4B7A47CD_at_wt.net>



Can this be done? The documentation is not clear.

Example

SQL > _at_my_script.sql parm1 parm2

my_script.sql

set serveroutput on

declare

[Quoted] 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;

Thanks,

Don Hal
Received on Sat May 04 2002 - 07:31:17 CEST

Original text of this message