Call now: 252-767-6166  
Oracle Training Oracle Support Development Oracle Apps

 E-mail Us
 Oracle Articles
New Oracle Articles

 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog

 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Oracle Support

 SQL Tuning

 Oracle UNIX
 Oracle Linux
 Remote s
 Remote plans
 Application Server

 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S


 Consulting Staff
 Consulting Prices
 Help Wanted!


 Oracle Posters
 Oracle Books

 Oracle Scripts

Don Burleson Blog 








ORA-00932 inconsistent datatypes tips

Oracle Error Tips by Burleson Consulting


The Oracle oerr utility notes this about ORA-00932:
   ORA-00932:  inconsistent datatypes: expected string got string

Cause: One of the following:

- An attempt was made to perform an operation on incompatible datatypes. For example, adding a character field to a date field (dates may only be added to numeric fields) or concatenating a character field with a long field.

- An attempt was made to perform an operation on a database object (such as a table or view) that is not intended for normal use. For example, system tables cannot be modified by a user. Note that on rare occasions this error occurs because a misspelled object name matched a restricted object's name.

- An attempt was made to use an undocumented view.
Action: If the cause is different datatypes, then use consistent datatypes. For example, convert the character field to a numeric field with the TO_NUMBER function before adding it to the date field. Functions may not be used with long fields.
an object not intended for normal use, then do not access the restricted object.

ORA-00932 and export (expdp or exp)

If you have a BLOB or CLOB data types in the table, run these dictionary scripts as 

SQL> connect sys/xxxx as sysdba 
SQL> @?/rdbms/admin/catmetx.sql 
SQL> @?/rdbms/admin/utlrp.sql 

Also if you have any table cluster definitions, see MOSC Note 339938.1 which 
describes where a export fails with an ORA-932 when exporting the cluster definitions. 
Also see this forum thread on the ORA-00932 error during an export (expdp, exp) 
1. Create the database again with the NLS_LENGTH_SEMANTICS= BYTE (The database was created in byte)
3. Deinstall and Reinstall XDB using Catnoqm.sql and Catqm.sql. 


Possible bug and ORA-00932 error


Oracle technical support offers information regarding ORA-00932 in reference to a bug which throws the error while trying to use dynamic select statement.   This bug is seen in PL/SQL versions on any platform. 


The symptoms of this bug consist of ORA-00932 when trying to use a dynamic select statement Though it was functional in, it does fail in 10g. 

ORA-00932 is caused by the statement you were intending to use with the Native Dynamic SQL in which the amount of items have to be the same in the SELECT and INTO lists.  Upon experiencing ORA-00932, you may want to research bug 4381035.


As a workaround to ORA-00932 with the bug, the SELECT statement should have equal define variables and columns.  You should also note that ORA-00932 will not occur with the specifics of this bug in 11.x versions. 



Oracle Training at Sea
oracle dba poster

Follow us on Twitter 
Oracle performance tuning software 
Oracle Linux poster


Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


Copyright © 1996 -  2020

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.


Hit Counter