Oracle Error Message
ORA-00060: deadlock detected while waiting for resource
Reason for the Error
Your session and another session are both waiting for a resource that the other has locked.
This is referred to as a deadlock.
To break the impasse, one or more statements were rolled back so that the other session could continue working. In simple words, You attempted to execute a statement, but your session was stalled because another session had locked the same resource.
The statement(s) you attempted to execute have been reverted.
You can attempt to re-execute the statement(s) that were rolled back after a brief delay. (OR) All statements that have been executed since the last COMMIT can be re-executed by performing a ROLLBACK.