Re: SQL*Loader problem

In article <217ac5a8.0212060637.747e597_at_posting.google.com>, charlie3101_at_hotmail.com wrote:

>I've got a little problem with SQL*Loader.
>
>I'm trying to load records into a table (of course!). For each file I
>load, I want to create a record in the "PAYMENT_FILES" table. So what
>I did was to create an index on the "PAYMENT_RECORDS" table like this:
>
>CREATE OR REPLACE TRIGGER pr_trg_1
> BEFORE INSERT
Why are you activating the trigger BEFORE the row has been INSERTED by SQL*LOADER? If you use AFTER, it won;t do funny things when a row is kicked out (unless I am totally overlooking something).

-- 
======================================================================
ISLAM: Winning the hearts and minds of the world, one bomb at a time.