How to use cascade delete?
I am trying to do a cascade delete and I keep getting a "Mutating Table"
error. Without adding constraints, how do I properly set up a
"delete on
row" trigger that triggers another "delete on row" trigger?
Ans1:
use the ON DELETE CASCADE option with the declaritve integrity constraint
-- you
must have a foreign key defined (else you would not get the mutating
table
error) -- just make it an 'on delete cascade' foreign key.