Transactions on remote databases

[GMonce]

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

[Mark D Powell]

Re: Transactions on remote databases

gmonce@adinet.c om.uy (GMonce) wrote in message news:<fa5e70af. 0408061243.77d5 7575@posting.go ogle.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 --