SQL*Loader crash
Date: 2000/05/26
Message-ID: <ifzX4.892$R7.171332_at_juliett.dax.net>#1/1
SQL*Loader occasionally crash when I try to load a record of data that contains an error:
Here is the situation:
The data record is loaded into a temporary table. This temporary table has
an AFTER INSERT trigger, that triggers a procedure in a PL/SQL block. This
procedure is going to distribute the data into the 'real' tables in the
database. When the error occurs, the procedure is supposed to throw an
exception, that should be logged in the .log file produced by SQL*Loader.
The wrecked record should also be written into a .bad or .dsc file. These
files contain important information for the system we are building.
Instead of acting nice, the loader crashes, and it produces a .log and a
.bad file that contains no data whatsoever (0KB).
Do anybody have an idea of how to solve my problem? Received on Fri May 26 2000 - 00:00:00 CEST