• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

StoredProcedure Issue

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

I am invoking a Oracle StoredProcedure, I am able to compile it without any issues, but when I run it I am getting the below errors:-

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

I have used an Oracle DATALINK to connect to the connect to a remote schema for this operation.

CREATE PUBLIC DATABASE LINK TEST_LINK CONNECT TO test IDENTIFIED BY test USING 'localhost:1521/testSID';
Please let me know what is the problem here?

Thanks
 
Roel De Nijs
Sheriff
Posts: 10662
144
AngularJS Chrome Eclipse IDE Hibernate Java jQuery MySQL Database Spring Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You are not providing many details, so don't expect to get much help. Maybe this post might give you some pointers.
 
Brian Tkatch
Bartender
Posts: 567
25
Linux Notepad Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Rithanya Laxmi wrote:Hi,

I am invoking a Oracle StoredProcedure, I am able to compile it without any issues, but when I run it I am getting the below errors:-

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

I have used an Oracle DATALINK to connect to the connect to a remote schema for this operation.

CREATE PUBLIC DATABASE LINK TEST_LINK CONNECT TO test IDENTIFIED BY test USING 'localhost:1521/testSID';
Please let me know what is the problem here?

Thanks


The error is rather descriptive, you cannot do that without a ROLLBACK. Just because you can compile an SP does not mean you can execute it. Compilation and execution check different things.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic