Fwd: "ORA - 02067 -transaction or savepoint rollback required".

Can anyone guide me on this please?

Thanks
Ann

• Forwarded message ---------- From: Anant <shastry17_at_gmail.com> Date: Jun 27, 2007 11:14 AM Subject: Fwd: "ORA - 02067 -transaction or savepoint rollback required". To: anantha.shivashankar_at_caritor.com
• Forwarded message ---------- From: Anant <shastry17_at_gmail.com> Date: Wed, 27 Jun 2007 10:35:57 +0530 Subject: "ORA - 02067 -transaction or savepoint rollback required". To: oracle-l_at_freelists.org

Hi all,

I am facing the below error when running the script. The script actually doing the selects the table( from remote DB) and inserts and updates to that table. Meanwhile it is throwing "ORA - 02067
-transaction or savepoint rollback required". Initially I had a dblink
error and resolved it.

Other sources says:

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 savepoint or rollback the transaction and resubmit.

Adding to the above point:
Is it is a transaction of an inactive session which was on the archiving table on the remote database. if so how can I find out and kill that session, so that i can restart the batch to see if it works fine.Is my appraoch correct?.
Can anyone show me the light on this and guide me please?.

Thanks in advance,
Anant
--

http://www.freelists.org/webpage/oracle-l Received on Wed Jun 27 2007 - 20:37:36 CDT