Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Shell script

523888Feb 10 2007 — edited Feb 12 2007
I 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 ?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 12 2007
Added on Feb 10 2007
22 comments
1,320 views