Re: AFTER ROW Trigger Vs BEFORE ROW

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Sun, 10 Jul 2005 07:04:08 -0400
Message-ID: <-MqdnW_Dp-MwnUzfRVn-oA@comcast.com>

"Geoff Bruce" <gb_at_hsb.com> wrote in message news:42d0cd8f$1_3_at_rain.i-cable.com...
> Hi Daniel,
>
> But, why? Isnt it that I can still write into my audit table in the
> BEFORE
> ROW trigger.
>
> "DA Morgan" <damorgan_at_psoug.org> ¦b¶l¥ó news:1120971919.711558_at_yasure
> ¤¤¼¶¼g
> ...
>> Geoff Bruce wrote:
>> > It seems to me that whatever I can do in AFTER ROW trigger, I can do it
> in
>> > BEFORE ROW.
>> >
>> > Are there any functionalities that can only be achieved by AFTER ROW
> trigger
>> > but not BEFORE ROW?
>>
>> Auditing
>> --
>> Daniel A. Morgan
>> http://www.psoug.org
>> damorgan_at_x.washington.edu
>> (replace x with u to respond)
>
>

AFTER row will not fire if the DML fails -- so you put actions in there that you don't want to attempt unless all database constraints succeed (which is somewhat of a performance issue, and may be a transaction issue if autonomous transactions are used in the triggers)

++ mcs Received on Sun Jul 10 2005 - 06:04:08 CDT