Re: Oracle Distributed Transactions

From: DA Morgan <damorgan_at_exxesolutions.com>
Date: Tue, 08 Apr 2003 07:19:03 -0700
Message-ID: <3E92DA57.7305E05B@exxesolutions.com>

Karen wrote:

> 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

I'm not sure where you are looking for your syntax but I'd drop the SET TRANSACTIONstuff. I don't know why you would issue it.

But the following works

INSERT INTO table_at_database_link VALUES (....);

Daniel Morgan Received on Tue Apr 08 2003 - 09:19:03 CDT