Catching SQL*Loader errors

My question is simple: How does one catch SQL*Load errors ? A typical error when loading a table is a table that cannot be extended.

In SQL*Plus I can write:

WHENEVER SQLERROR EXIT FAILURE but what about SQL*Loader ?

One method is to scan through the logfile for the word "ERROR" (or something like that), but I think you will agree that this is not a nice solution to the problem.

I'm on a VMS system. Apparently the $STATUS symbol reflects that there has been an error when loading at table. Is this a safe method to use ?

How about you ? How do you solve the problem ? I would like to hear from you even if you are not on a VMS system.

Please respond to this newsgroup or to syntese_at_login.dkuug.dk

Jesper Partoft,
Denmark   Received on Tue Apr 26 1994 - 08:50:34 CEST