ORA-02067: transaction or savepoint rollback required

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: Roll back to a previous savepoint or roll back the transaction and resubmit.

Regards,
Hemant.

-----Original Message-----
From: suguna
[mailto:oracledba-ezmlmshield-x99557864.[Email address protected]
Sent: Thursday, January 05, 2006 9:31 PM
To: LazyDBA Discussion
Subject: ORA-02067


Hi,
Can anyone pls let me know the reason for the following error:

ORA-02067: transaction or savepoint rollback required

And how it can be solved.


With regards,
S.Suguna


-


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page