Re: Question about triggers

Hooman wrote:
> Hi all,
>
> Do triggers start firing upon completion of the commit transaction?
>
> For example, if I have updated tables T1 and T2, and I have a trigger
> on T1 that depends on T2 transactions getting committed, do I need to
> make sure T2 gets commited first and then commit T1? Or could I simply
> commit once and the T1 trigger gets fired after both tables are
> commited?
>

You might also consider learning about mutating table issues: http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96590/adg13trg.htm#786

(search for mutating tables on asktom.oracle.com if this applies to your situation.)

jg

--
@home.com is bogus.
Fire up the grill!
http://www.cbc.ca/toronto/story/to-gotransit20060502.html