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()
