Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Question about triggers

Re: Question about triggers

From: Brian Peasland <oracle_dba_at_nospam.peasland.net>
Date: Thu, 25 May 2006 14:43:22 GMT
Message-ID: <IztswI.L1B@igsrsparc2.er.usgs.gov>


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
Received on Thu May 25 2006 - 09:43:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US