Reposted by Zoran Tica
Take care if you have
Foreign keys with ON DELETE [ CASCADE | SET NULL ]
Triggers on the table querying the parent
This can lead to ORA-04091 mutating trigger errors when you delete parent rows in Oracle Database
@zorantica.bsky.social discusses workarounds
buff.ly
Oracle Database - Foreign Key Constraints and mutating Triggers
An Issue If You have foreign keys in Your database (and chances are huge, if You're using a relational database like Oracle properly ...
