Oracle/PLSQL: ORA-00060 Error

Error:

ORA-00060: deadlock detected while waiting for resource

Cause:

You tried to execute a statement, but your session was deadlocked because another session had the same resource locked. The statement(s) that you tried to execute have been rolled back.

Action:

The options to resolve this Oracle error are:

You can wait a few minutes and try to re-execute the statement(s) that were rolled back.
You can execute a ROLLBACK and re-execute all statements since the last COMMIT was executed.