Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Is there a SQLLOAD Return Code? - Reply

Re: Is there a SQLLOAD Return Code? - Reply

From: Peter A. Udom <paudom_at_PTES.COM>
Date: Thu, 18 Jan 1996 13:52:55 -0800
Message-Id: <9601182240.AA17680@alice.jcc.com>


salutations;
if U are in a UNIX env - sqlloader will create a log file if requested this is
perhaps a candidate for pattern searching or matching using AWK &/or SED.

peter

>>> Bambi Bellows <Bambi_Bellows_at_PO.CHI02_at_SMTPLINK.INFORES.COM> 01/18
8:42 am >>>

     Dave --

     Most Oracle tools do not return an error code when they fail;
     but, I was pleasantly surprised to find out that sql*loader
     does (at least on our configuration)... you may want to test
     this at your site by entering a bad control file and checking
     the return code (echo $?).

     If that doesn't work, you may want to redirect the stdout and stderr
     into some file and grep for error conditions.

     HTH,
     Bambi.

Received on Thu Jan 18 1996 - 17:40:26 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US