You entered a query with a UNION, INTERSECT, or MINUS set operator in which corresponding columns have different types--for example, column 1 in the first SELECT statement has datatype CHAR, while column 1 in the second SELECT statement has datatype NUMBER.
Action:
Modify the SELECT statements so that all corresponding columns have the same datatype.
Note: For help on other error messages, see Finding error message help.
Copyright © 1984, 2005, Oracle. All rights reserved.