ORA-26052: Unsupported type number for SQL expression on column string.

Cause : The direct path api does not support a SQL expression on a column of that type.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Make sure the types are correct.

update : 22-09-2017

ORA-26052 - Unsupported type number for SQL expression on column string.
ORA-26052 - Unsupported type number for SQL expression on column string.

  • ora-38446 : Error with embedded ADT "string" in the attribute set.
  • ora-04005 : INCREMENT must be less than MAXVALUE minus MINVALUE
  • ora-25014 : cannot change the value of a PARENT reference variable
  • ora-31055 : A null XMLType element cannot be inserted into RESOURCE_VIEW
  • ora-32772 : BIGFILE is invalid option for this type of tablespace
  • ora-24270 : a row already exists in the string table for these parameters
  • ora-30749 : column string not enabled to store objects of type string.string
  • ora-15047 : ASM file name 'string' is not in multiple-file creation form
  • ora-13774 : insufficient privileges to select data from the workload repository
  • ora-02227 : invalid cluster name
  • ora-02372 : data for row: string
  • ora-30390 : the source statement is not equivalent to the destination statement
  • ora-14132 : table cannot be used in EXCHANGE
  • ora-26742 : Maximum number of ignored transactions exceeded
  • ora-00069 : cannot acquire lock -- table locks disabled for string
  • ora-12205 : TNS:could not get failed addresses
  • ora-37007 : (AWLISTALL05) number writer
  • ora-30033 : Undo tablespace cannot be specified as default user tablespace
  • ora-00050 : operating system error occurred while obtaining an enqueue
  • ora-38448 : Indexing predicates with "string" operator is not supported.
  • ora-14280 : all rows in table do not qualify for specified subpartition
  • ora-07501 : scgtoa: $deq unexpected return
  • ora-02238 : filename lists have different numbers of files
  • ora-13358 : circle type does not contain 3 points
  • ora-30965 : fragment does not fit into the VARCHAR2 VALUE column
  • ora-19679 : RMAN configuration number string is outside valid range of 1 through string
  • ora-01185 : logfile group number string is invalid
  • ora-01716 : NOSORT may not be used with a cluster index
  • ora-30333 : dimension does not exist
  • ora-31535 : cannot support change source string in this configuration
  • 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.