Re: Trigger Question

Me

>>=============================================================
>>CREATE OR REPLACE TRIGGER USA_Contractor_BI
>> BEFORE INSERT
>> ON USA_Contractor
>> FOR EACH ROW
>> WHEN (:old.contractor_id IS NULL)
>>declare
>> newid number;
>> begin
>> select USA_Contractor_seq.nextval
>> into newid from dual;
>>
>> :new.Contractor_Key := newid;
>> :new.Contractor_ID := 'CID' || LPAD(TO_CHAR(newid), 5, '0');
>> :new.Create_Date := sysdate;
>>END USA_Contractor_BI;
>>==============================================================

You:

> You can't check for :old on an insert. :old.* will always be null on an 
> insert. You should be checking WHEN (:new.contractor_id IS NULL).
> If the record being inserted already has a contractor_id then the trigger 
> will not fire. 

Thank you. I included the above example because I made a mistake in it when I said: "WHEN (:old...." because you don't use the ":" in this section.

Your correction was what I needed to get it to work! Received on Fri Mar 22 2002 - 21:12:21 CET