Re: Trigger

Hi,

It seems only update trigger specify columns. Try

create or replace trigger mytrigger
after insert on t1
begin
insert into t2 values (:new.client_id, 'xxx-xxx-xxxx'); end;

<abouf066_at_aix2.uottawa.ca> wrote in message news:Pine.A41.3.96.1001202130226.43050A-100000_at_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 - 14:54:31 CST