Re: Deferred Triggers in 10g?

On Fri, 07 May 2004 11:57:03 -0700, Domenic wrote:

> Does Oracle support deferred triggers in 10g? I mean, only fired at
> commit time vs statement time?
>
> Domenic.

Oracle supports "after" statement triggers which will be fired after statement execution, thus causing the subsequent commit, but not the statement itself to fail. To my knowledge, it is the situation since Oracle7 (7.0 to be exact) and I haven't heard of any changes in Oracle 10g. Deferred constraints are supported since Oracle8. I would seriously question designs which would heavily rely on the commit processing, because "commit" is a global event which should make the outcome of my transaction permanent, and should, generally speaking, be of very short duration. I wouldn't want to have heavy validation and processing done during the commit time.

-- 
Trust me, I know what I'm doing. (Sledge Hammer)