-- ---- ---- ---- Ron Reidy Lead DBA Array BioPharma, Inc.
-- --Original Message-- -- From: Marquez, Chris [mailto:cmarquez@(protected)] Sent: Wednesday, August 31, 2005 9:34 AM To: Reidy, Ron; oracle-l@(protected) Subject: RE: PART II: - Beyond a basic Oracle EXP/IMP shell script: Error Handling & Exit Status?
Ron,
>>typeset -i rc=`path_to_script [arg1 ...]`
I think I get it? This line appears to retrieve RC to imp_wrapper.sh, from imp_script.sh and interrogate? [Reidy, Ronald] Yes. The code between the back ticks (` ... `) executes in a sub shell. when the sub shell terminates, it's return code is saved into the variable rc (which is an integer type). But what (line/code) executes the imp_script.sh?...the same line? [Reidy, Ronald] Yes.
PS If you solve this one for me too I going have to start referencing you in my shell script and crediting you in my status reports! ;o) [Reidy, Ronald] Cool. Do I get on the payroll also ;D
Thanks,
Chris Marquez
-- --Original Message-- -- From: Reidy, Ron [ <mailto:Ron.Reidy@(protected)> mailto:Ron.Reidy @(protected)] Sent: Wed 8/31/2005 11:19 AM To: Marquez, Chris; oracle-l@(protected) Subject: RE: PART II: - Beyond a basic Oracle EXP/IMP shell script: Error Handling & Exit Status?
to trap the error code:
typeset -i rc=`path_to_script [arg1 ...]` if [[ $rc -ne 0 ]]; then # exit appropriately fi
You might also want to liik at this: <http://www.samag.com/documents/s=9238 /sam0408f/0408f.htm> http://www.samag.com/documents/s=9238/sam0408f/0408f.htm
-- ---- ---- ---- Ron Reidy Lead DBA Array BioPharma, Inc.
-- --Original Message-- -- From: oracle-l-bounce@(protected) [ <mailto:oracle-l-bounce@(protected)> mailto:oracle-l-bounce@(protected)]On Behalf Of Marquez, Chris Sent: Wednesday, August 31, 2005 9:11 AM To: oracle-l@(protected) Subject: PART II: - Beyond a basic Oracle EXP/IMP shell script: Error Handling & Exit Status?
In my original quest for help I was working with one script. (btw with you help/code I did complete this task...works well, thanks!)
Now I have a new problem that I do not know how to deal with. I have a wrapper script involved this time.
Something like this;
===== imp_wrapper.sh ...
#RUN THIS SCRIPT script1.sh
#RUN THIS FUNCTION do func1
#RUN THE IMP SCRIPT imp_script.sh
#RUN THIS SCRIPT script2.sh
#RUN THIS FUNCTION do func2
# RETURN CODE: Set next Return Code. RC=$? echo 'RETURN CODE' >> $log_file 2>&1 echo $RC >> $log_file =====
My imp_script.sh has "trap" code and "RETURN CODE" syntax/value also in the script.
But I need to be able to STOP/EXIT/END the parent script; imp_wrapper.sh and set $?=1 when child scrip; imp_script.sh fails with RC=1?
Meaning if import.sh; RC=1, then I want imp_wrapper.sh; RC=1 immediately and exit?
This confuses me and I have no idea how to pass child (exit) RC to the parent script.
Thanks in advance,
Chris Marquez Oracle DBA
This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system.
This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <TITLE>RE: PART II: - Beyond a basic Oracle EXP/IMP shell script: Error Handling & Exit Status?</TITLE>
<META content="MSHTML 6.00.2800.1505" name=GENERATOR></HEAD> <BODY> <DIV><FONT face=Arial color=#0000ff size=2><SPAN class=217293815-31082005>Comments below ...</SPAN></FONT></DIV> <DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV> <P><FONT face=Arial size=2>-- ---- ---- ----</FONT> <BR><FONT face=Arial size=2>Ron Reidy</FONT> <BR><FONT face=Arial size=2>Lead DBA</FONT> <BR><FONT face=Arial size=2>Array BioPharma, Inc.</FONT> <BR></P> <DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma size=2>-- --Original Message-- --<BR><B>From:</B> Marquez, Chris [mailto:cmarquez@(protected)]<BR><B>Sent:</B> Wednesday, August 31, 2005 9:34 AM<BR><B>To:</B> Reidy, Ron; oracle-l@(protected)<BR><B>Subject:</B> RE: PART II: - Beyond a basic Oracle EXP/IMP shell script: Error Handling & Exit Status?<BR><BR></FONT></DIV><!-- Converted from text/plain format --> <P><FONT size=2>Ron,<BR><BR>>>typeset -i rc=`path_to_script [arg1 ...]`<BR><BR>I think I get it?<BR>This line appears to retrieve RC to imp_wrapper.sh, from imp_script.sh and interrogate?<BR><SPAN class=217293815-31082005><FONT face=Arial color=#0000ff>[Reidy, Ronald] Yes. The code between the back ticks (` ... `) executes in a sub shell. when the sub shell terminates, it's return code is saved into the variable rc (which is an integer type). </FONT></SPAN><BR>But what (line/code) executes the imp_script.sh?...the same line?<BR><SPAN class=217293815-31082005><FONT face=Arial color=#0000ff>[Reidy, Ronald] Yes. </FONT></SPAN><BR><BR >PS If you solve this one for me too I going have to start referencing you in my shell script and crediting you in my status reports!<BR> ;o)<BR><SPAN class=217293815-31082005><FONT face=Arial color=#0000ff>[Reidy, Ronald] Cool. Do I get on the payroll also ;D </FONT></SPAN><BR><BR>Thanks,<BR><BR>Chris Marquez<BR><BR>-- --Original Message-- --<BR>From: Reidy, Ron [</FONT><A href="mailto:Ron.Reidy@(protected)"><FONT size=2>mailto:Ron.Reidy@(protected)</FONT></A><FONT size=2>]<BR>Sent: Wed 8/31/2005 11:19 AM<BR>To: Marquez, Chris; oracle-l@(protected)<BR>Subject: RE : PART II: - Beyond a basic Oracle EXP/IMP shell script: Error Handling & Exit Status?<BR><BR>to trap the error code:<BR><BR>typeset -i rc=`path_to_script [arg1 ...]`<BR>if [[ $rc -ne 0 ]]; then<BR> # exit appropriately<BR>fi<BR><BR>You might also want to liik at this: </FONT><A href="http://www.samag.com/documents/s=9238/sam0408f/0408f.htm"><FONT size=2>http://www.samag.com/documents/s=9238/sam0408f/0408f.htm</FONT></A><BR> <BR><BR><FONT size=2>-- ---- ---- ----<BR>Ron Reidy<BR>Lead DBA<BR>Array BioPharma, Inc.<BR><BR> -- --Original Message-- --<BR>From: oracle-l-bounce@(protected) [</FONT><A href="mailto:oracle-l-bounce@(protected)"><FONT size=2>mailto:oracle-l-bounce@(protected)</FONT></A><FONT size=2>]On Behalf Of Marquez, Chris<BR>Sent: Wednesday, August 31, 2005 9:11 AM<BR>To: oracle-l@(protected)<BR>Subject: PART II: - Beyond a basic Oracle EXP/IMP shell script: Error Handling & Exit Status?<BR><BR><BR><BR><BR>In my original quest for help I was working with one script.<BR>(btw with you help/code I did complete this task...works well, thanks!)<BR><BR>Now I have a new problem that I do not know how to deal with.<BR>I have a wrapper script involved this time.<BR><BR>Something like this;<BR><BR>=====<BR>imp_wrapper.sh<BR>...<BR><BR>#RUN THIS SCRIPT<BR>script1.sh<BR><BR>#RUN THIS FUNCTION<BR>do func1<BR><BR>#RUN THE IMP SCRIPT<BR>imp_script.sh<BR><BR>#RUN THIS SCRIPT<BR>script2.sh<BR><BR>#RUN THIS FUNCTION<BR>do func2<BR><BR># RETURN CODE: Set next Return Code.<BR>RC=$?<BR>echo 'RETURN CODE' >> $log_file 2>&1<BR>echo $RC >> $log_file<BR>=====<BR><BR>My imp_script.sh has "trap" code and "RETURN CODE" syntax/value also in the script.<BR><BR>But I need to be able to STOP/EXIT/END the parent script; imp_wrapper.sh and set $?=1 when child scrip; imp_script.sh fails with RC=1?<BR><BR>Meaning if import.sh; RC=1, then I want imp_wrapper.sh; RC=1 immediately and exit?<BR><BR>This confuses me and I have no idea how to pass child (exit) RC to the parent script.<BR><BR>Thanks in advance,<BR><BR>Chris Marquez<BR>Oracle DBA<BR><BR><BR><BR>This electronic message transmission is a PRIVATE communication which contains<BR>information which may be confidential or privileged. The information is intended<BR>to be for the use of the individual or entity named above. If you are not the<BR>intended recipient, please be aware that any disclosure, copying, distribution<BR>or use of the contents of this information is prohibited. Please notify the<BR>sender of the delivery error by replying to this message, or notify us by<BR>telephone (877-633-2436, ext. 0), and then delete it from your system.<BR><BR><BR></FONT></P></BODY><P align=left style="MARGIN-RIGHT: 0px"> <FONT face=Tahoma size=2><FONT color=#0000ff> <HR> </FONT></FONT><FONT face=Tahoma size=2><FONT color=#0000ff>This electronic message transmission is a PRIVATE communication which contains information <BR >which may be confidential or privileged. The information is intended to be for the use of the individual <BR>or entity named above. If you are not the intended recipient, please be aware that any disclosure, <BR>copying, distribution or use of the contents of this information is prohibited. Please notify the sender <BR>of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), <BR>and then delete it from your system.</FONT></FONT></P></HTML>
