Oracle Error ORA-31054: The string operator cannot have an ancillary operator

Oracle Error Message

ORA-31054: The string operator cannot have an ancillary operator

Reason for the Error

An ancillary operator was used with an operator which does not does not support ancillary operators

Solution

Remove the ancillary operator in the query