Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Distributed Transactions
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
![]() |
![]() |