Philip Greenspun's Homepage : Philip Greenspun's Homepage Discussion Forums : 6916 : One Thread
what's wrong with this trigger definition?
There is no compilation errors, but
it keeps failing re-validation when it's triggered.
create or replace trigger person_insert_trigger
after insert on person for each row
insert into site_wide_index (table_name, the_key,
values ('person', :new.id, :new.name, 'a');
-- Linda Lin, April 11, 2000
Is there a foreign key references between the the two tables, if so, then it could cause a trigger mutation when fired.
-- xiaodong shao, May 19, 2000