• Post Reply Bookmark Topic Watch Topic
  • New Topic

Transaction or Savepoint rollback required error for the Stored Procedure

 
Rithanya Laxmi
Ranch Hand
Posts: 190
  • 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: 568
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.
 
my overalls have superpowers - they repel people who think fashion is important. Tiny ad:
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!