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 |
UDI-00015: invalid context or job state for parameter, 'string'.
ORA-19800: Unable to initialize Oracle Managed Destination
KUP-03017: length specified for VARIABLE records must be greater than 0
ORA-23366: integer value string is less than 1
TNS-12609: TNS: Receive timeout occurred
ORA-14152: invalid number of partitions specified in PARTITIONS clause
ORA-30037: Cannot perform parallel DML after a prior DML on the object
PLS-00399: different types of columns in UNION, INTERSECT, or MINUS expression
PCB-00218: RENAMES clause not allowed for host variable "string"
ORA-00327: log string of thread string, physical size string less than needed string
ORA-25252: listen failed, the address string is a non-persistent queue
ORA-24328: illegal attribute value