Problem Rolling back a Distributed Transaction
Hi,
I was wondering if any of you guys have encountered the following problem using system.transactions object.
I have two databases running Oracle 8.1.4.7.0 and have Oracle 9i client. When i run distributed transaction on these two databases and raise an exception to see if the transaction is able to rollback, the transaction rollsback on one database and does not rollback on the other. There are also some more problem on the Database on which the transaction does not rollback : If i try to delete data and rollback, the Index / Primary key gets deleted BUT the data does not get deleted. i.e. you cannot query the data by using the Primary Key but when you select all the records, you will be able to see the data. This is also not a one time occurance as I am able to recreate the error.
p.s. If their are no exceptions I am able to commit the transactions.
Any help is much appreciated.
Thank you,
Vivek
