Oracle Error ORA-32640: FOR LIKE loops are not allowed for multi-byte character types

Oracle Error Message

ORA-32640: FOR LIKE loops are not allowed for multi-byte character types

Reason for the Error

FOR LIKE loops was specified for a multi-byte character type.

Solution

Check the SQL statement and rewrite if necessary.