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 |
O2I-00115: Error opening the HFILE file
DRG-11440: operation not supported for the string language
CLSR-00512: Invalid CAA trigger event type [string]
TNS-12661: Protocol authentication to be used
KUP-04000: error initializing IO state for file string in string
ORA-32816: foreign queue string is referenced by a subscriber or schedule
ORA-07500: scglaa: $cantim unexpected return
NID-00603: No datafiles found in database
ORA-31468: cannot process DDL change record
ORA-13025: polygon does not close
ORA-13361: not enough sub-elements within a compound ETYPE
ORA-00069: cannot acquire lock -- table locks disabled for string