Another way is:
Code:TargetInstance="" SourceInstance="" Rerun="N" ReturnStatus=0 sqlplus -s /nolog << !EOF >> $LOG 2>&1 whenever sqlerror exit 99 connect apps/$PWD var l_return_status number; exec :l_return_status := 0; declare begin CLONE_SETUP.clone_main('$TargetInstance','$SourceInstance','$Rerun', :l_return_status); if :l_return_status = 0 then commit; else rollback; end if; end; / exit :l_return_status !EOF ReturnStatus=$? if [ ReturnStatus -eq 0 ]; then echo 'Rapid Clone succeeded, Commit performed' else echo 'Rapid Clone failed, Rollback performed' fi exit![]()




Reply With Quote