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 : 26-07-2017
ORA-26052

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

  • ora-29819 : cannot associate default values with columns
  • ora-30508 : client logon triggers cannot have BEFORE type
  • ora-01610 : recovery using the BACKUP CONTROLFILE option must be done
  • ora-00164 : distributed autonomous transaction disallowed within migratable distributed transaction
  • ora-09792 : sllfop: cannot allocate read buffer.
  • ora-38458 : invalid operation "string" for XPATH_FILTER_PARAMETERS
  • ora-39124 : dump file name "string" contains an invalid substitution variable
  • ora-29378 : invalid consumer group mapping priorities
  • ora-07456 : cannot set RESOURCE_MANAGER_PLAN when database is closed
  • ora-29335 : tablespace 'string' is not read only
  • ora-07401 : sptrap: cannot restore user exception handlers.
  • ora-16785 : the database is not in ARCHIVELOG mode
  • ora-33068 : (XSAGDNGL33) In AGGMAP workspace object, the hierarchy dimension QDR over dimension workspace object must specify a positive dimension offset.
  • ora-00256 : cannot translate archive destination string string
  • ora-23505 : Object "string"."string" is missing.
  • ora-30556 : functional index is defined on the column to be modified
  • ora-31531 : could not find column string in CDC subscriber view string.string
  • ora-02178 : correct syntax is: SET TRANSACTION READ { ONLY | WRITE }
  • ora-26688 : missing key in LCR
  • ora-00566 : cannot request processor group - NUMA not enabled
  • ora-32615 : incorrect use of MODEL IS ANY predicate
  • ora-13383 : inconsistent network metadata: string
  • ora-23476 : cannot import from string to string
  • ora-30770 : Cannot specify storage options for fixed size opaque type
  • ora-00213 : cannot reuse control file; old file size string, string required
  • ora-14302 : only one list of added-LOB-storage-clauses can be specified in a statement
  • ora-08205 : ora_addr: $ORACLE_SID not set in environment
  • ora-38760 : This database instance failed to turn on flashback database
  • ora-01916 : keyword ONLINE, OFFLINE, RESIZE, AUTOEXTEND or END/DROP expected
  • ora-12652 : String truncated
  • 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.