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

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

Oracle Error Message

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

Reason for the Error

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.

Solution

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.

Share:

Leave a Reply

You May Also Like

Oracle Error Message CLSGN-32767: Internal error. Reason for the Error An unexpected error occurred. Solution Examine the message(s) that accompany...
Oracle Error Message CLSGN-00211: OCR batch operation failed. string Reason for the Error Setting a set of Oracle Cluster Registry...
Oracle Error Message CLSGN-00210: failed to get value for OCR key “string”. string Reason for the Error It was not...