I have a table with one-to-many relationship to itself. The delete
option in the referential integrity is cascade.

When I try to delete the parent record I receive message trigger failled. Why if I use delete cascade?