Oracle Distributed Transactions

Can anyone tell me if oracle supports distributed transactions?

I am trying to execute the following

set transaction read write

    insert into a remote table via a DB Link - This should succeed     insert into a remote table via a DB Link - This should fail commit;

The second one fails but the first one is not rolled back..

I have already set the ODBC connection to disable MTS support.

Am I missing something?

Any information would be greatly appreciated. Karen Received on Tue Apr 08 2003 - 07:09:03 CDT