set echo off prompt prompt ================================================================================ prompt call_compile.sql &1 &2 &3 &4 &5 prompt
set echo off pagesize 0 feedback off verify off serveroutput on size 1000000
define v_input_un = &1
define v_input_pw = &2
define v_input_conn_str = &3
define v_reconnect_un = &4
define v_reconnect_pw = &5
define v_compile_work_file = ./log/compile_work_file_&v_input_un..sql
--
-- reconnect to make sure the following pl/sql block can be run successfully
--
connect &v_reconnect_un/&v_reconnect_pw@&v_input_conn_str
set echo off pagesize 0 feedback off verify off serveroutput on size 1000000
-- -- construct the work file --
spool &v_compile_work_file
begin
if ('&v_input_un' = '&v_na') then
dbms_output.put_line('-- Skipping this user ...');
else
dbms_output.put_line('@gen_compile &v_input_un &v_input_pw &v_input_conn_str');
end if;
end;
/
spool off
--
-- call the work file
--
@&v_compile_work_file