Oracle DBA, How To, Error, Cause and Action

ORA-01424: missing or illegal character following the escape character

ORA-01424: missing or illegal character following the escape character




Cause: The character following the escape character in LIKE pattern is missing or not one of the escape character, '%', or '_'.




Action: Remove the escape character or specify the missing character.