Re: Question about triggers

Hooman wrote:
> Thanks everyone for their reply.
>
> So in the case of my scenario, how should I proceed? The trigger fired
> on T1 needs to ensure that the data required is already modified in T2.
>
> However, T1 and T2 both get updated by the same transaction. Do I need
> to separate the transactions? Meaning that I have to update and commit
> T2 before T1?
>

Since T1 and T2 both get updated by the same transaction, T1 will be able to see all changes made by T2 even if the data is not yet committed. So you should only need one commit...at the end of the transaction.

Please read the Oracle Concepts Guide
(http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14220/toc.htm) as this contains lots of information on transactions in an Oracle database.

HTH,
Brian

-- 
===================================================================

Brian Peasland
oracle_dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown