Oracle DB Error ORA-22998 CLOB or NCLOB in multibyte character set not supported

The following is the cause of this error:

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 you can take to resolve this issue: Use DBMS_LOB functions such as DBMS_LOB.INSTR() and DBMS_LOB.SUBSTR() or use PLSQL DBMS_LOB.READ/WRITE to access LOB data.

Tags: Database, Microsoft, Oracle, SQL, Software, DBMS, Error Messages, Directory

Related