set echo off prompt prompt ================================================================================ prompt call_grant_dml.sql &1 prompt

set echo off pagesize 0 feedback off verify off serveroutput on size 1000000

define v_input_grantee       = &1

define v_grant_dml_work_file = ./log/grant_dml_work_file_&v_input_grantee..sql

--

-- construct the work file

--

spool &v_grant_dml_work_file

begin

  if ('&v_input_grantee' = '&v_na') then

    dbms_output.put_line('-- Skipping this user ...');

  else

    dbms_output.put_line('@gen_grant_dml &v_input_grantee');

  end if;

end;

/

spool off

--

-- call the work file

--

@&v_grant_dml_work_file