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 |
DRG-10827: open_con must be performed before count_last
ORA-14177: STORE-IN (Tablespace list) can only be specified for a LOCAL index on a Hash or Composite Range Hash table
ORA-28040: No matching authentication protocol
RMAN-06205: Uncataloged string objects
PCC-02320: arithmetic expression does not have correct operand types
PCC-02365: Indicator array size cannot be smaller than host array size
ORA-12566: TNS:protocol error
SQL-02125: Connect error, can't get error text
ORA-24507: invalid combination of character set ids
ORA-01905: STORAGE keyword expected
ORA-01128: cannot start online backup - file string is offline
QSM-00785: the directive string is not supported for task string at this time