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

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 - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

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

update : 18-08-2017

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

  • ora-13529 : Error occurred when flushing AWR table group
  • ora-23378 : connection qualifier "string" is not valid for object group "string"."string"
  • ora-30395 : dimension options require the COMPATIBLE parameter to be string or greater
  • ora-25145 : allocation policy already specified
  • ora-33413 : (EIFMAKEF01) You cannot export compressed composite workspace object because one of its bases has limited status or a PERMIT READ restriction.
  • ora-28140 : Invalid column specified
  • ora-02758 : Allocation of internal array failed
  • ora-38410 : schema extension not allowed for the table name
  • ora-08120 : Need to create SYS.IND_ONLINE$ table in order to (re)build index
  • ora-01079 : ORACLE database was not properly created, operation aborted
  • ora-28348 : index defined on the specified column cannot be encrypted
  • ora-00703 : maximum number of row cache instance locks exceeded
  • ora-16791 : unable to check the existence of the standby redo logs
  • ora-16552 : an error occurred when generating the CLIENT OPERATION table
  • ora-28554 : pass-through SQL: out of cursors
  • ora-06814 : TLI Driver: the SPX device file could not be opened
  • ora-10651 : incorrect file number block number specified
  • ora-22331 : cannot alter an incomplete type
  • ora-19809 : limit exceeded for recovery files
  • ora-07267 : spwat: invalid process number.
  • ora-13140 : invalid target type
  • ora-23357 : the propagator does not exist
  • ora-25508 : database is not mounted
  • ora-14165 : MODIFY DEFAULT ATTRIBUTES FOR PARTITION may not be combined with other operations
  • ora-26752 : Unsupported LCR received for "string"."string"
  • ora-09702 : sem_acquire: cannot acquire latch semaphore
  • ora-01743 : only pure functions can be indexed
  • ora-23402 : refresh was aborted because of conflicts caused by deferred txns
  • ora-23446 : duplicate template site
  • ora-08437 : invalid picture type in picture mask
  • Oracle Database Error Messages

    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.