Oracle DBA, How To, Error, Cause and Action

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

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




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




Action: Change it to a character string of length 1.