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 : 26-06-2017
ORA-22998

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

  • ora-22314 : method information mismatch in ALTER TYPE
  • ora-01301 : error writing to file during flat file build
  • ora-14251 : Specified subpartition does not exist
  • ora-24778 : cannot open connections
  • ora-06565 : cannot execute string from within stored procedure
  • ora-30506 : system triggers cannot be based on tables or views
  • ora-31496 : must use DBMS_CDC_PUBLISH.DROP_CHANGE_TABLE to drop change tables
  • ora-39772 : column array reset disallowed after OCI_CONTINUE or OCI_NEED_DATA
  • ora-14023 : creation of GLOBAL partitioned cluster indices is not supported
  • ora-25004 : WHEN clause is not allowed in INSTEAD OF triggers
  • ora-35017 : (QFCHECK06) The Analytic Workspace and EIF file definitions of workspace object have different partitioning methods.
  • ora-01264 : Unable to create string file name
  • ora-29336 : Internal error [string] [string] from DBMS_PLUGTS
  • ora-07671 : $IDTOASC failed translating an integrity category
  • ora-10946 : trace name context forever
  • ora-40002 : wordsize must be string or greater
  • ora-38748 : cannot flashback data file string - file is in use or recovery
  • ora-14287 : cannot REBUILD a partition of a Composite Range partitioned index
  • ora-06806 : TLI Driver: could not complete protocol initialization for SPX
  • ora-30658 : attempt was made to create a temporary table with EXTERNAL organization
  • ora-00398 : abort thread recovery due to reconfiguration
  • ora-01353 : existing Logminer session
  • ora-39058 : current object skipped: string of type string
  • ora-19223 : XP0003 - syntax error in XQuery expression
  • ora-01201 : file string header failed to write correctly
  • ora-13758 : "SQL Tuning Set" "string" owned by user "string" is in use.
  • ora-30338 : illegal dimension hierachy name
  • ora-14288 : index is not partitioned by Composite Range method
  • ora-00358 : Too many file members specified, the maximum is string
  • ora-31009 : Access denied for property string
  • 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.