Mutating tables, Constraints, and triggers

Hi all!

We are having a mutating table problem and we are wondering if anyone has any advice for us.

We have a database in which foreign key constraints are defined for our relationships. Upon insertion into a parent table we have an After Insert trigger for each row which performs an insert into child tables. At the time we attempt to perform an insert into the parent table we receive an ORA-4091 'parent table is mutating ' error on the first insert statement into a child table within the body of the trigger from the parent table. From what we've read in various books, the constraints places the parent table into a 'mutated' state which is checked prior to allowing a child table to be written against. Does anyone have a suggestion on how to get around this? Any suggestions on how to maintain our data integrity and perform these types of operations?

Thanks in advance for your help!

Nathan Stiltner Received on Wed Dec 11 1996 - 00:00:00 CST