Re: Is there a SQLLOAD Return Code? - Reply

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.