Re: Trigger

In this trigger (for each row), table T1 is mutating: it tries to access T1 (to check
the foreign key) while T1 is currently updating

abouf066_at_aix2.uottawa.ca a écrit :

> Can anybody tell me what is wrong with this trigger :
> (It is supposed to insert in table t2 a new record after insertion is made
> in table t1. By the way, T2 has a foreign key referencing T1)
>
> create or replace trigger mytrigger
> after insert of client_id on t1
> begin
> insert into t2 values (:new.client_id, 'xxx-xxx-xxxx');
> end;
> /
>
> Thanks a lot.
>
> _____________________________________________________________
>
> LaBoufarikoise
Received on Thu Dec 07 2000 - 07:53:04 CST