Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!nntp.flash.net!newsfeed.mathworks.com!news.maxwell.syr.edu!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: yong321@yahoo.com (Yong Huang)
Newsgroups: comp.databases.oracle.server
Subject: Re: sqlldr question?
Date: 9 Sep 2003 10:19:48 -0700
Organization: http://groups.google.com/
Lines: 19
Message-ID: <b3cb12d6.0309090919.28e8f8cc@posting.google.com>
References: <vlq2os144kigdc@corp.supernews.com> <Hoj7b.519$nF1.309@news01.roc.ny>
NNTP-Posting-Host: 155.188.191.4
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1063127990 28880 127.0.0.1 (9 Sep 2003 17:19:50 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 9 Sep 2003 17:19:50 GMT
Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:242705

"Anurag Varma" <avdbi@hotmail.com> wrote in message news:<Hoj7b.519$nF1.309@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