Shell script
523888Feb 10 2007 — edited Feb 12 2007I am executing a shell script through nohup command and the code is written below
#! /bin/sh
set -x
ORACLE_SID=oracle;
export ORACLE_SID
sqlplus /nolog <<EOF
connect abc/abc1223@oracle;
set time on;
set timing on;
spool RPARUNLOG_2.LOG
select to_char(sysdate,'dd-mm-yyyy hh24:mi:ss') from dual;
alter rollback segment R02 shrink;
SET TRANSACTION USE ROLLBACK SEGMENT R02;
exec Rep_Proc('01-jan-2005' ,'31-mar-2005');
commit;
alter rollback segment R02 shrink;
SET TRANSACTION USE ROLLBACK SEGMENT R02;
exec Rep_Proc('01-apr-2005' ,'30-jun-2005');
commit;
alter rollback segment R02 shrink;
SET TRANSACTION USE ROLLBACK SEGMENT R02;
exec Rep_Proc('01-jul-2005' ,'30-sep-2005');
commit;
select to_char(sysdate,'dd-mm-yyyy hh24:mi:ss') from dual;
spool off;
Exit;
EOF
This script is currenlty executing and if i change the shell script to remove last 2 calls for procedure Rep_Insert_Inv_Pay_Wxpa while its executing. Then will these two calls will be executed or not ?