ORA-00932
expression
failed_expression
is of data type
expression_data_type
, which is incompatible with expected data type
expected_data_type
-
failed_expression
: The expression with the incompatible data type.
-
expression_data_type
: The data type of the column or expression.
-
expected_data_type
: The data type expected by the SQL operation.
Cause
The input data type for this SQL operation was incompatible with the expected data type.
Action
Modify the expression to have a compatible data type for the SQL operation.
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 was 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.
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 was 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.
