Re: Trigger compilation problem

OLD and NEW values are available in AFTER UPDATE TRIGGERS. They are also available in AFTER INSERT Triggers but the OLD values make no sense and are always null.
for example
create table x(a number);
create table y(b number);
create or replace trigger tx after insert on x for each row begin
insert into y values(:old.a);
end;
insert into x values(1);
set feedback 1
select * from x;

         A

         1

1 row selected.
select * from y;

         A

1 row selected.

This shows that null is inserted in Y

regards
Srivenu Received on Fri Nov 08 2002 - 05:56:04 CST