Home » RDBMS Server » Server Administration » Rollback to savepoints in a distributed transaction
Rollback to savepoints in a distributed transaction [message #369953] Fri, 17 November 2000 04:47 Go to next message
P. Lavanya
Messages: 8
Registered: November 2000
Junior Member
Hi,

Can anyone help me out with the following problem?

I have some procedures in a database which are called in another procedure in a different database. All procedures in database 1 aswell as database 2 have savepoints and rollbacks to the savepoints. When I execute the procedure in database 2, it gives me an error:
ORA-02074: Cannot ROLLBACK in a distributed transaction.
ORA-02074: Cannot SET SAVEPOINT in a distributed transaction.

Please help!!

Thanks,
Lavanya

Report message to a moderator

Re: Rollback to savepoints in a distributed transaction [message #370113 is a reply to message #369953] Sat, 16 December 2000 09:49 Go to previous message
Noel Navarrete
Messages: 1
Registered: December 2000
Junior Member
Do you get this error when you run in a single DB only? try running first without distributed trans,
and if it's not successfull, include "PRAGMA AUTONOMOUS_TRANSACTION" in your Procs.
Hope this one might help.

Report message to a moderator

Previous Topic: Read/write an ASCII file
Next Topic: Please help us ....
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jan 18 11:19:38 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.