Database Error Messages

OCI-01790

expression must have same datatype as corresponding expression

Cause

A SELECT list item corresponds to a SELECT list item with a different datatype in another query of the same set expression.


Action

Check that all corresponding SELECT list items have the same datatypes. Use the TO_NUMBER, TO_CHAR, and TO_DATE functions to do explicit data conversions.