trigger error

Philip Greenspun's Homepage : Philip Greenspun's Homepage Discussion Forums : 6916 : One Thread
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
     insert into site_wide_index (table_name, the_key,
one_line_description,  datastore)
       values ('person',,, '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