This week's book giveaway is in the Agile and Other Processes forum.
We're giving away four copies of The Little Book of Impediments (e-book only) and have Tom Perry on-line!
See this thread for details.
Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Transaction or Savepoint rollback required error for the Stored Procedure

 
Rithanya Laxmi
Ranch Hand
Posts: 185
  • 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: 567
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