Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Commit operation fail in a distributed transaction

Commit operation fail in a distributed transaction

From: Paul Nguyen <rashomon_at_ev1.net>
Date: 18 Dec 2001 10:53:10 -0600
Message-ID: <3c1f7476$1_1@newsa.ev1.net> 






I have two store procedure on in system a , other in system b.
A procedure call B procedure via DB link.
B procedure do this:


  update a table.


  commit


  exception when others 


     roll back.


this is the error I have:



update fail in distributed transaction. required rolback.
rollback operation fail in distributed transaction.



Please help me to fix this problem.



thanks.
Received on Tue Dec 18 2001 - 10:53:10 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US