Mutations - again......

Folks,
how the heck can this trigger fail on a mutating table ?? (The FKs are restrict)

/Kjetil

• --- --- --- --- --- --- --- PROMPT Creating Trigger PRCON_INS CREATE OR REPLACE TRIGGER prcon_ins AFTER INSERT ON PROJ_CONSTITUENTS FOR EACH ROW BEGIN INSERT INTO masterlist_data
  (projno, too, object, con_too, con_object, str)
  VALUES (:new.projno, :new.too, :new.object, :new.con_too, :new.con_object, :new.str);

  INSERT INTO technical_specs
(projno, too, object, con_too, con_object, str)
  VALUES (:new.projno, :new.too, :new.object, :new.con_too,

                 :new.con_object, :new.str);

  INSERT INTO shipping_data
(projno, too, object, con_too, con_object, str)
  VALUES (:new.projno, :new.too, :new.object, :new.con_too,

                 :new.con_object, :new.str);

END; Received on Tue Feb 13 1996 - 13:58:56 CST