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 |
ORA-12433: create trigger failed, policy not applied
ORA-30340: illegal dimension name
ORA-25964: column type incompatible with join column type
ORA-36208: (XSAGOP05N) In AGGMAP workspace object, you can only specify NAOPERATOR string with the PROPORTIONAL or EVEN operators, not string.
ORA-01033: ORACLE initialization or shutdown in progress
ORA-06928: CMX: wrong ORACLE_SID
ORA-37001: You have one or more attached but unupdated analytic workspaces.
ORA-01600: at most one "string" in clause "string" of string
ORA-29349: tablespace 'string' already exists
NID-00490: LOG being redirected to STDERR due to errors.
IMG-00717: destination image format does not support process options
DRG-11102: assigned lexer can not operate on string language setting