Transactions & views in Oracle.

Posts   
 
    
the_narv avatar
the_narv
User
Posts: 8
Joined: 15-Dec-2004
# Posted on: 29-Apr-2005 09:40:01   

Please IGNORE this message for the time being as it may be incorrect. I am investigating further.

Hoping someone can advise...

This is an Oracle 8i database.

I have a partly completed transaction and I need to be able to see uncommitted updates from within it. It seems that if you add an entity to the transaction (even though you have no intention of updating it) then it allows you to see those uncommitted updates. This does not seem to be possible with a view, as it does not appear you can add views to a transaction.

Is there any way I can see those uncommitted changes in a TypedView?

Thanks in advance,

Adam.