How to fix the Oracle error ORA-36691: (NTEXTCNV02) Invalid escape sequence in argument to UNISTR function: string.?

In this post, you’ll learn more about the Oracle ErrorORA-36691: (NTEXTCNV02) Invalid escape sequence in argument to UNISTR function: string. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-36691: (NTEXTCNV02) Invalid escape sequence in argument to UNISTR function: string.

Reason for the Error ORA-36691: (NTEXTCNV02) Invalid escape sequence in argument to UNISTR function: string.

The user called the UNISTR function on a string that had an invalid escape sequence. The only valid escape sequences in UNISTR are 1.) an escape-escape sequence, and 2.) an escape, followed by exactly four hexadecimal digits.

How to fix the Error ORA-36691: (NTEXTCNV02) Invalid escape sequence in argument to UNISTR function: string. ?

You can fix this error in Oracle by following the below steps

Make sure that all escape sequences in UNISTR arguments are exactly four hexadecimal digits. To represent codepoints whose value is less than 0x1000, use preceding zeros. WRONG: 0x10; RIGHT: 0x0010.