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 -> How can I avoid getting ORA-02074: cannot Rollback in a distributed transaction ?

How can I avoid getting ORA-02074: cannot Rollback in a distributed transaction ?

From: Per Bengtsson <per.x.bengtsson_at_telia.se>
Date: 25 Oct 2002 05:31:26 -0700
Message-ID: <99af783d.0210250431.781418ce@posting.google.com> 





I get "ORA-02074: cannot Rollback in a distributed transaction" and 
"ORA-02074: cannot Set Savepoint in a distributed transaction" when calling
a Stored Procedure from a (Delphi) ADO application using OraOLEDB.



How can I get around it ?


Do I have to remove all ROLLBACK, COMMIT and SET SAVEPOINT from the
procedure ?


I tried to call ADOConnection.BeginTrans and ADOConnection.CommitTrans before and
after the call to the procedure but it didn't help.



Need help !



/Per Bengtsson
Received on Fri Oct 25 2002 - 07:31:26 CDT












Original text of this message













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