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 : 27-05-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-31508 : invalid parameter value for synchronous change set
  • ora-00327 : log string of thread string, physical size string less than needed string
  • ora-30054 : invalid upper limit snapshot expression
  • ora-01566 : file specified more than once in ALTER DATABASE
  • ora-03283 : specified datafile string does not exist
  • ora-24437 : OCIStmtExecute called before OCIStmtPrepare2.
  • ora-12019 : master table is a synonym to a remote object
  • ora-36401 : (XSSPROPOTYPE) Property string may only be applied to objects of type string.
  • ora-00365 : the specified log is not the correct next log
  • ora-16239 : IMMEDIATE option not available without standby redo logs
  • ora-19117 : invalid redefinition of predefined namespace prefix 'string'
  • ora-12624 : TNS:connection is already registered
  • ora-29928 : duplicate default selectivity specified
  • ora-31162 : element or attribute "string" has no SQLType specified
  • ora-31160 : max substitution group size string exceeded by "string" (string) for head element "string" (string)
  • ora-22331 : cannot alter an incomplete type
  • ora-39049 : invalid parameter name string
  • ora-22852 : invalid PCTVERSION LOB storage option value
  • ora-28279 : Error reading ldap_directory_access init parameter.
  • ora-19689 : cannot have more than one %F in control file autobackup format(string) for string
  • ora-00444 : background process "string" failed while starting
  • ora-31616 : unable to write to dump file "string"
  • ora-36847 : (XSLMGEN17) AW name is blank
  • ora-09367 : Windows 3.1 Two-Task driver unable to deallocate shared memory
  • ora-22828 : input pattern or replacement parameters exceed 32K size limit
  • ora-16812 : log apply service not running on apply instance recorded by the broker
  • ora-37075 : (XSMCSESS03) You cannot rename a session-only dimension value.
  • ora-14290 : PRIMARY KEY constraint mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION
  • ora-19212 : no key columns specified before call to DBMS_XMLSTORE.updateXML()
  • ora-02472 : PL/SQL functions not allowed in hash expressions
  • 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.