Re: Sinhronization of 2 transactions

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 8 Nov 2004 06:37:35 -0800
Message-ID: <2687bb95.0411080637.3bfbf110@posting.google.com>

markodudic_at_yahoo.com (Marko Dudi?) wrote in message news:<9b67811e.0411080307.244de6cf_at_posting.google.com>...
> I have 2 transactions. First collection of transactions starts before
> second and ends (commit) after the start of second transaction,
> therefor in second transaction i don't see the data from first
> transaction.
> How can i detect that first transaction is started or when its ends?
> I think that only solution is to detect start or end time of first
> transaction, and start second transaction in one of that times.
> But how to do that?
>
> marko

The Oracle data consistency model does not allow transaction B to see uncommited work of transaction A.

If you need to insure that the row targeted by B is not being accessed by another process then use select for update in both transactions.

A more detailed explanation of the problem may allow someone to provide more specific advice.

HTH -- Mark D Powell -- Received on Mon Nov 08 2004 - 08:37:35 CST