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.
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 HalReceived on Sat May 04 2002 - 07:31:17 CEST