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

Oracle Error Message

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

Reason for the 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.

Solution

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