| Notify me of new responses |
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 BEGIN insert into site_wide_index (table_name, the_key, one_line_description, datastore) values ('person', :new.id, :new.name, 'a'); END; /
-- 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