Re: sqlldr question?

From: Yong Huang <yong321_at_yahoo.com>
Date: 9 Sep 2003 10:19:48 -0700
Message-ID: <b3cb12d6.0309090919.28e8f8cc@posting.google.com>

"Anurag Varma" <avdbi_at_hotmail.com> wrote in message news:<Hoj7b.519$nF1.309_at_news01.roc.ny>...
>
> sqlldr parfile=$PARFILE > $LOGFILE 2>&1
> rc=$?
>
> case "$rc" in
> 0) echo "SUCCESS: SQL*Loader execution successful" >> $LOGFILE ;;
> 1) echo "ERROR: SQL*Loader execution exited with EX_FAIL, see logfile"; exit >>$LOGFILE ;;
> 2) echo "WARN: SQL*Loader execution exited with EX_WARN, see logfile" >>$LOGFILE ;;
> 3) echo "ERROR: SQL*Loader execution encountered a fatal error"; exit >>$LOGFILE ;;
> *) echo "ERROR: SQL*Loader unknown return code $rc"; exit >>$LOGFILE ;;
> esac

To make this message complete, the return codes on Windows are different. According to Metalink Note:191041.1 or 50444.1, what's returned on UNIX, 0,1,2,3, changes to 0,3,2,4, respectively. On VMS, they're different again.

Yong Huang Received on Tue Sep 09 2003 - 12:19:48 CDT