ORA-22998: CLOB or NCLOB in multibyte character set not
supported



ORA-22998: CLOB or NCLOB in multibyte character set not supported..

Answer / guest

Cause: A CLOB or NCLOB in a fixed-width or varying-width
multibyte character set was passed to a SQL character
function which does not support multibyte LOB data.

Action: Use DBMS_LOB functions such as DBMS_LOB.INSTR() and
DBMS_LOB.SUBSTR()

Please add more information about this Error

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-13618: The value string is not a valid value for procedure argument string.

1 Answers  


TNS-12541: TNS:no listener

1 Answers  


TNS-12598: TNS:banner registration failed

1 Answers  


NNO-00321: statistic counter dump disabled

1 Answers  


ORA-29319: datafile string is not correct

1 Answers  






ORA-38466: user does not have privileges to CREATE/MODIFY expressions

1 Answers  


PLS-00378: invalid compilation unit for this release of PL/SQL

1 Answers  


ORA-38311: cannot purge objects owned by other users

1 Answers  


ORA-12609: TNS: Receive timeout occurred

1 Answers  


ORA-30732: table contains no user-visible columns

1 Answers  


NNL-00290: Cancelled cache flush

1 Answers  


ORA-14174: only a <parallel clause> may follow COALESCE PARTITION|SUBPARTITION

1 Answers  


Categories