Oracle Error ORA-23624: A comparison operation is currently in progress for string.

Oracle Error Message

ORA-23624: A comparison operation is currently in progress for string.

Reason for the Error

Another session was already performing an operation on this object.

Solution

Retry the operation once other sessions are done with the specific comparison object.