Forum OpenACS Q&A: Re: ORA-04091 Problem with trigger, when deleting acs_rels

Have a look at http://osi.oracle.com/~tkyte/Mutate/index.html to see how Thomas Kyte provides a solution for your problem.