Re: Accessing data before commit

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?

Yes, by creating message communication between the two processes using Advanced Queuing. Process A queues a message after insert, which Process B dequeues.
By reading the table: NO.
Obviously one would wonder why you want to parallelize an essentially serialised algorithm. Usually this kind of approach ends in hell.

-- 
Sybrand Bakker
Senior Oracle DBA