Cascade delete vs trigger when deleting on child table
705103Feb 11 2010 — edited Feb 11 2010Hi,
I have a Cascade delete set up on 7 tables. Besides the firs one (which is the parent) , on all the "child" tables, o every INSERT/DELETE/UPDATE, I need to update the "parent" tables's LAST_UPDATED_DATE. I went ahead and created a trigger for this on each "child" table.
The issue i have is that when I try to cascade delete some record from the "parent" , it tells me that the "table is mutating" when the child trigger is in place, and i see this makes perfect sence, but how can i bypass this?
Kind regards
Alex