Shell Programming and Scripting

Hi,
Running Oracle Scheduler 11g2 on an AIX 6.01.
I want to run a shell script (called "external program" in Oracle terminology) which executes some commands and react on the outcome using the exit status $?. For example a "cat thisfiledoesnotexist" and then get the $? which should be not zero. My script operates perfectly when ran from the command line, but when ran from Oracle Scheduler the $? is always zero...
My script has she-bang ksh
What is happening? Why is jobcc (see script below) always zero after exit13.sh finisched and ... can I work around this? I have looked for traps, coprocess, ...?

The main script called by Oracle Scheduler:

Code:

#!/bin/ksh
ofl="/var/stpweb/spool/stpjw02_"`date +"%Y%m%d%H%M%S"`".log"
jobcc=0
echo "Script 08-06-2010 08:14:47" >>$ofl
echo "WHOAMI="`whoami` >>$ofl
echo "Start /home/app/axi/stpweb/exec/sh/exit13.sh" >>$ofl
/home/app/axi/stpweb/exec/sh/exit13.sh
jobcc=${?}
echo "THE EXIT CODE IS: ${jobcc}" >>$ofl
exit ${jobcc}

The exit13.sh:

Code:

#!/bin/ksh
exit 13

Moderator's Comments:

Use code tags please, ty.

Code:

jobcc=${?}
echo "THE EXIT CODE IS: ${jobcc}" >>$ofl

if [[ $? ]]
then 
echo "the exit code is : ${jobcc}" >> $ofl

try this it might work.. for u looking for

Hello dazdseg,

That does not work either. I even tried setting a "trap ErrorHandler ERR" and even that error-trap does not fire after a "cat nonexistingfile". This is so weird...

---------- Post updated 2010-06-10 at 12:46 PM ---------- Previous update was 2010-06-09 at 05:19 PM ----------

It's not solved but the work around has been found in using an Oracle Scheduler Agent.

can you explain me in lil more details what ru trying to do. i think i am not able to understand what exactly ur trying to do.

We were trying to get Oracle Scheduler to run on AIX6. But in the ksh scripts that were ran thru Oracle Scheduler the exit status of a program or other script was not passed back into the $?. In fact: if we checked the $? is was set to 0 in some miraculous way. We were trying to figure out how to avoid that, e.g. by starting another process that would not be messed up by the Oracle Scheduler (as we think is what is happening).
But we have found a work around and now focus on getting our work ready in time ;-)

umm let me know if u need any help. i will try too help as much as i can.

Thanks dazdseg. I will post again if necessary.