• Post Reply Bookmark Topic Watch Topic
  • New Topic

Transaction or Savepoint rollback required error for the Stored Procedure  RSS feed

 
Rithanya Laxmi
Ranch Hand
Posts: 191
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I am creating a database link to access the remote DB and I am using that remote table in Stored Procedure.Below are the details:-



When I run the above SP , I am getting the below error:-

ORA-02067: transaction or savepoint rollback required
ORA-02067: transaction or savepoint rollback required
ORA-00604: error occurred at recursive SQL level 1
ORA-02067: transaction or savepoint rollback required

It seems that this is due to the remote access using database link.

Cause: A failure (typically a trigger or stored procedure with multiple
remote updates) occurred such that the all-or-nothing execution
of a previous Oracle call cannot be guaranteed.
Action: rollback to a previous save point or rollback the transaction
and resubmit.

Please let me know how to solve this issue?

Thanks.
 
Brian Tkatch
Bartender
Posts: 569
25
Linux Notepad Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Rithanya Laxmi wrote:Please let me know how to solve this issue?


What to do? Don't do that!

This is an Oracle question, not a java question. You are trying to do something that Oracle does not allow. If you need help, please ask in the Oracle PL/SQL forum.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!