PLS-00399: different types of columns in UNION, INTERSECT,
or MINUS expression
Answer / guest
Cause: The select lists to the left and right of a UNION,
INTERSECT, or MINUS expression select at least one column
that is mismatched in datatype. For example, the following
statement is faulty because the constant 3 has datatype
NUMBER, whereas SYSDATE has datatype DATE: CURSOR my_cur IS
SELECT 3 FROM emp INTERSECT SELECT SYSDATE FROM emp;
Action: Change the select lists so that they match in
datatype. You might want to use datatype conversion
functions in the select list of one or more queries.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
NZE-29040: There are no supported cipher suites.
ORA-32308: object materialized views must use SELECT *
ORA-07598: spwat: $SETIMR failure
DRG-12803: invalid text datatype
ORA-10614: Operation not allowed on this segment
ORA-14014: maximum number of partitioning columns is 16
DRG-10011: invalid object name string
NZE-28777: binding creation failure
ORA-06560: pos, string, is negative or larger than the buffer size, string
ORA-22370: incorrect usage of method string
TNS-04209: Trace Assistant Internal ERROR: Type Error
ORA-13638: The user interrupted the current operation.