Oracle Error ORA-01425: escape character must be character string of length 1

Oracle Error Message

ORA-01425: escape character must be character string of length 1

Reason for the Error

Given escape character for LIKE is not a character string of length 1.

Solution

Change it to a character string of length 1.