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 : 23-05-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-13861 : Statistics aggregation for client identifier string is already enabled
  • ora-10382 : parallel query server interrupt (reset)
  • ora-31529 : could not find publication for CDC subscriber view string.string
  • ora-15083 : failed to communicate with ASMB background process
  • ora-32315 : REFRESH FAST of "string"."string" unsupported after mixed DML and Direct Load
  • ora-07444 : function address string is not readable
  • ora-02495 : cannot resize file string, tablespace string is read only
  • ora-00020 : maximum number of processes (string) exceeded
  • ora-25465 : variable name not specified
  • ora-32008 : error while processing parameter update at instance string
  • ora-28236 : invalid Triple DES mode
  • ora-26098 : direct path context is not prepared
  • ora-32051 : mapping service not available
  • ora-09926 : Unable to set effective privilege set of the server
  • ora-01509 : specified name 'string' does not match actual 'string'
  • ora-02494 : invalid or missing maximum file size in MAXSIZE clause
  • ora-32585 : duplicate specification of a supplemental log attribute
  • ora-13389 : unable to compute buffers or intersections in analysis function
  • ora-23535 : instantiating templates from multiple back ends is not allowed.
  • ora-36696 : (XSRELTBL02) QDR dimension workspace object should not be the related dimension of the relation.
  • ora-23611 : tablespace "string" has more than one data file
  • ora-30188 : reserved for future use
  • ora-36886 : (XSSRF05) Error rewritting OLAP DML expression. Rewritten expression is greater than number bytes
  • ora-04071 : missing BEFORE, AFTER or INSTEAD OF keyword
  • ora-39136 : cannot specify an SCN on a transportable job
  • ora-23443 : missing template parameter
  • ora-03278 : duplicate ALLOCATE EXTENT option specification
  • ora-26669 : parameter string inconsistent with parameter string
  • ora-04063 : %s has errors
  • ora-28583 : remote references are not permitted during agent callbacks
  • 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.