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



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

Answer / guest

Cause: 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.

Action: 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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

QSM-02054: DISTINCT clause in select list in mv

1 Answers  


ORA-16068: redo log file activation identifier mismatch

2 Answers  


LCD-00161: ORACLE error (possible syntax error) parameter [string]

1 Answers  


DRG-50950: circular SQE found

1 Answers  


ORA-22910: cannot specify schema name for nested tables

1 Answers  






SQL*Loader-00308: %s SQL string of column string must be in double quotes.

1 Answers  


ORA-28180: multiple authentication methods provided by proxy

1 Answers  


ORA-36636: (XSDUNION04) The unique concat dimension workspace object cannot be changed to NOT UNIQUE, because it is a base of at least one other unique concat dimension.

1 Answers  


QSM-01050: roll-up check failed for materialized view, string

1 Answers  


ORA-01197: thread string only contains one log

1 Answers  


ORA-14135: a LOB column cannot serve as a partitioning column

1 Answers  


ORA-14168: only one subpartition may be modified

1 Answers  


Categories