[PL/SQL] Distributed transaction

Hi,

I have application which performs distributed transaction. Function 'ONE' on computer A calls remote function 'TWO' on computer B. Function 'TWO' returns integer indicating status of the remote operation. If function 'TWO' returns 0 then function 'ONE' calls COMMIT, otherwise calls ROLLBACK.
So I have two questions related to the above situation:

1. What happens if connection between computers is broken??? Does function 'ONE' receives exception ??
2. Connection is broken. Function 'ONE' knows about it and calls ROLLBACK. But function 'TWO' keeps handling blockades on some rows. Application on comuter B side is not able to modify these records but i want it to be able to modify any records. How can I force distributed transaction to rollback changes on computer B if the connection is broken.

Thank you very much for any help.
Szalas Received on Tue Jul 22 2003 - 06:16:20 CDT