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

 
 Home
 E-mail Us
 Oracle Articles


 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog


 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Analysis
 Design
 Implementation
 Oracle Support


 SQL Tuning
 Security

 Oracle UNIX
 Oracle Linux
 Monitoring
 Remote s
upport
 Remote plans
 Remote
services
 Application Server

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

 Remote S
upport  
 Development  

 Implementation


 Consulting Staff
 Consulting Prices
 Help Wanted!

 


 Oracle Posters
 Oracle Books

 Oracle Scripts
 Ion
 Excel-DB  

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 
SYS:

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)
 
2. Change NLS_LENGTH_SEMANTICS to CHAR. 
 
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 10.1.0.0-10.2.0.2 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 9.2.0.4, 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 performance tuning software 
 
oracle dba poster
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 -  2014

All rights reserved by Burleson

Oracle ? is the registered trademark of Oracle Corporation.


Hit Counter