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

Home -> Community -> Usenet -> comp.databases.oracle -> Transactions on remote databases

Transactions on remote databases

From: GMonce <gmonce_at_adinet.com.uy>
Date: 6 Aug 2004 13:43:06 -0700
Message-ID: <fa5e70af.0408061243.77d57575@posting.google.com> 





Hi. We have a problem we'd like to circumvent. There is a stored
procedure that sets a savepoint, do whatever, and if there is an
error, it rollbacks to the savepoint. The problem is that every time
we invoke that procedure from a remote database, oracle complains
because you cannot do that. ¿Could some of you know/imagine how to
circumvent that? We need the rollback to assure the integrity of data
after the procedure is called...



thanks 


guillermo
Received on Fri Aug 06 2004 - 15:43:06 CDT












Original text of this message













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