Transactions on remote databases
From: GMonce <gmonce_at_adinet.com.uy>
Date: 6 Aug 2004 13:43:06 -0700
Message-ID: <fa5e70af.0408061243.77d57575_at_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...
Date: 6 Aug 2004 13:43:06 -0700
Message-ID: <fa5e70af.0408061243.77d57575_at_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