Re: After statement level trigger iring before after row level trigger
From: Laurenz Albe <invite_at_spam.to.invalid>
Date: Thu, 19 Mar 2009 10:47:30 +0100
Message-ID: <1237456071.547224_at_proxy.dienste.wien.at>
PeteDaMeat wrote:
> I have a database table which has an after statement level trigger
> firing before the after row level trigger, does anyone have any
> suggestions as to what could be causing this?
Date: Thu, 19 Mar 2009 10:47:30 +0100
Message-ID: <1237456071.547224_at_proxy.dienste.wien.at>
PeteDaMeat wrote:
> I have a database table which has an after statement level trigger
> firing before the after row level trigger, does anyone have any
> suggestions as to what could be causing this?
This is caused by the Oracle database engine.
The behaviour is documented in
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14220/triggers.htm#i13362
For enabled triggers, Oracle automatically performs the following actions:
- Oracle runs triggers of each type in a planned firing sequence when more than one trigger is fired by a single SQL statement. First, statement level triggers are fired, and then row level triggers are fired. [...]
- Oracle fires multiple triggers in an unspecified, random order, if more than one trigger of the same type exists for a given statement; that is, triggers of the same type for the same statement are not guaranteed to fire in any specific order.
Yours,
Laurenz Albe
Received on Thu Mar 19 2009 - 04:47:30 CDT