Re: sqlldr question?

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Tue, 09 Sep 2003 12:08:07 GMT
Message-ID: <Hoj7b.519$nF1.309@news01.roc.ny>

"Anthony Reeves" <areeves_at_cableone.net> wrote in message news:vlq2os144kigdc_at_corp.supernews.com...
> does sqlldr return a return code?
>
> that is if sqlldr runs the control script does it return a 0 or 1?
>
>
>

From what I remember .. and looking at one of my scripts, the return codes are something like this:

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

Anurag Received on Tue Sep 09 2003 - 07:08:07 CDT