Home


ORA-00932: inconsistent datatypes: expected string got string

 Search more oracle errors :
Caution      

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.

Resolution   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.
Some Related Errors

ORA-00101: invalid specification for system parameter DISPATCHERS
ORA-00119: invalid specification for system parameter string
ORA-00160: Global transaction length %s is greater than maximum (%s)
ORA-00214: controlfile string version string inconsistent with file
ORA-00257: Archiver error. Connect internal only, until freed
ORA-00279: change string generated at string needed for thread string
ORA-00283: recovery session canceled due to errors
ORA-00289: suggestion : string
ORA-00314: log string of thread string, expected sequence# string doesnt match string
ORA-00376: file %s cannot be read at this time
ORA-00381: cannot use both new and old parameters for buffer cache size specification