Re: Accessing data before commit

From: Antonio Dell'elce <antonio.dellelce_at_gmail.com>
Date: 19 Dec 2006 09:58:20 -0800
Message-ID: <1166551100.591756.260040@48g2000cwx.googlegroups.com>

Ritvij wrote:
> is it anyhow possible to access data in a table which is not committed?
>
> we have two messages A, B coming from an application at the same
> time.
> hence 2 different processes are triggered in our application to process
> the two messages A and B parallely.
>
> Process B processes the data and inserts into table X, but still
> transaction is not complete and hence no comit.
> Process A running parallely meanwhile needs to check whether B has
> inserted data in table X to decide its processing.
>
> Is it possible?

Well... yes!

Autonomous transactions...

not exactly what you are describing but probably may fit into your model.

see Tom Kyte's article:

http://asktom.oracle.com/tkyte/autonomous/index.html

Antonio Received on Tue Dec 19 2006 - 11:58:20 CST