• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Bear Bibeault
  • Paul Clapham
  • Jeanne Boyarsky
  • Knute Snortum
Sheriffs:
  • Liutauras Vilda
  • Tim Cooke
  • Junilu Lacar
Saloon Keepers:
  • Ron McLeod
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Joe Ess
  • salvin francis
  • fred rosenberger

Transaction or Savepoint rollback required error for the Stored Procedure

 
Ranch Hand
Posts: 251
  • 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.
 
Bartender
Posts: 598
26
Oracle Notepad Linux
  • 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.
 
Get meta with me! What pursues us is our own obsessions! But not this tiny ad:
Java file APIs (DOC, XLS, PDF, and many more)
https://products.aspose.com/total/java
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!