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

Home -> Community -> Usenet -> c.d.o.server -> Accessing data before commit

Accessing data before commit

From: Ritvij <ritvijm_at_gmail.com>
Date: 19 Dec 2006 02:45:22 -0800
Message-ID: <1166525122.273313.322470@t46g2000cwa.googlegroups.com>


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? Received on Tue Dec 19 2006 - 04:45:22 CST

Original text of this message

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