Re: Oracle Distributed Transactions

karen.mcdonagh_at_singularity.co.uk (Karen) wrote in message news:<1c9de25f.0304080409.66a7602c_at_posting.google.com>...
> 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

See the Oracle8 SQL Reference Manual about distributed transactions under the rollback statement. Also see the Oracle8 Distributed Systems Manual. Available on docs.oracle.com, I believe.

jg

--
@home.com is bogus.
http://www.signonsandiego.com/news/business/20030409-9999_1b9beyster.html