Trigger

From: <abouf066_at_aix2.uottawa.ca>
Date: Sat, 2 Dec 2000 13:05:05 -0500
Message-ID: <Pine.A41.3.96.1001202130226.43050A-100000@aix2.uottawa.ca>

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 Sat Dec 02 2000 - 12:05:05 CST