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