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

Home -> Community -> Usenet -> c.d.o.misc -> Re: cannot rollback in a distributes transaction

Re: cannot rollback in a distributes transaction

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 21 Dec 2004 06:17:31 -0800
Message-ID: <1103638651.487037.45230@c13g2000cwb.googlegroups.com> 





What version of Oracle on what platform?  Is sp_test an anonymous
transaction or a regular transaction?



Generally speaking the commit or rollback you are attempting in sp_test
should be executed in the code on DB1 after the return from sp_test
based on the return from sp_test.  That is if sp_test encounters an
error it should return the error code to its remote caller and let the
caller determine what to do.



HTH -- Mark D Powell --
Received on Tue Dec 21 2004 - 08:17:31 CST












Original text of this message













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