Oracle DBA, How To, Error, Cause and Action

ORA-02067: transaction or savepoint rollback required

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