Re: Oracle trigger causing a deadlock

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: nigel.cl.thomas@xxxxxxxxxxxxxx
  • Date: Wed, 8 Sep 2010 09:25:23 -0700

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

Other related posts: