Re: Transactions on remote databases
Date: 9 Aug 2004 06:29:46 -0700
Message-ID: <2687bb95.0408090529.77cdf4d7_at_posting.google.com>
gmonce_at_adinet.com.uy (GMonce) wrote in message news:<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
> guillermo
If you do not intend to commit the changes why are you changing the data to being with? An explanation of what you are doing and why may result in someone being able to provide you a better methology.
Your Oracle version and platform could be important to the possible statements/features available to solve your problem.
When a newsgroup has subgroups you should generally post in the subgroups and not the newsgroup proper.
HTH -- Mark D Powell -- Received on Mon Aug 09 2004 - 15:29:46 CEST