Home » SQL & PL/SQL » SQL & PL/SQL » ORA-02067 & ORA-00604
ORA-02067 & ORA-00604 [message #195721] Sun, 01 October 2006 18:18 Go to next message
bvenkatrajan
Messages: 4
Registered: September 2006
Junior Member
I am trying to create a procedure that reads and writes data using 2 Db_links. As I execute the procedure I encounter the issue below. Not sure what I need to do to resolve this. I included a SAVEPOINT A right before the section I thought is throwing this error and a ROLLBACK command to the savepoint A in the exception handling section. This obviously does not work. Should I be doing something else???? Please advise and thanks for your help in advance.

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


BEGIN SP_DAILY_REPORT_BY_GROUP; END;

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


Elapsed: 00:00:00.78
Re: ORA-02067 & ORA-00604 [message #195788 is a reply to message #195721] Mon, 02 October 2006 07:13 Go to previous message
orausern
Messages: 817
Registered: December 2005
Senior Member
you should post the code of the procedure, the table structure of the tables involved and brief explanation of what the code is doing....
Previous Topic: Tough Query.
Next Topic: pattern matching of table names
Goto Forum:
  


Current Time: Sat Dec 10 16:40:14 CST 2016

Total time taken to generate the page: 0.10242 seconds