Re: Mutating problem when delete

Zhiping Nie wrote:

> My environment:Win2k & Oracle 9i2.
>
> There are two tables T1, T2 which have similar structure.
> T1 T2
> ------- -------------
> c1 c1
> c2 c2
> c3
>
> What I want to do is:
> whenever T1 gets a row in,
> T2 will get same row, and then the row in T1 will be deleted.
>
> Here is the example code:
> create trigger t1_trigger
> before insert on t1
> on each row
> referencing new as new old as old
> begin
> insert into t2 values(:new.c1, :new.c2);
> end;
>
> create trigger t2_trigger
> after insert on t2
> on each row
> referencing new as new old as old
> begin
> delete from t1 where c1=:new.c1;
> end;
>
> Is it possible to get it done?
> Thanks in advance!
>
> ZP

Why? Why not just insert the row directly into t2? All it appears to me you are doing is making a simple task difficult, unscalable, and error prone as you have discovered.

It is not that it can't be done. But why bother?

Dan Morgan Received on Thu Dec 12 2002 - 13:14:39 CST