Oracle Error PLS-00560: character set mismatch

Oracle Error Message

PLS-00560: character set mismatch

Reason for the Error

An expression was used that has the wrong character set for this context.

Solution

Adjust the expression, using TRANSLATE(… USING …) or by rethinking the logic.