Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sqlldr question?
"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