On Wed, Sep 8, 2010 at 2:19 AM, Nigel Thomas <nigel.cl.thomas@xxxxxxxxxxxxxx > wrote: > The autonomous transaction is presumably a trick to avoid the mutating > table restriction. Probably unwise! > > If so then there is a fundamental design error in the data model. Avoiding mutating tables can be done, but it is complicated. The explanation and sample code used to be at http://asktom.oracle.com/~tkyte/Mutate/ Now that Asktom has been upgraded to Apex, you may have difficulty finding the article. If all else fails, you can find it on archive.org: http://web.archive.org/web/20060128190225/http://asktom.oracle.com/~tkyte/Mutate/ Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: http://jkstill.blogspot.com Home Page: http://jaredstill.com