PLS-00399: different types of columns in UNION, INTERSECT,
or MINUS expression
- 1 Answers
- 2060 Views
- I also Faced
- E-Mail Answers
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-00604: error occurred at recursive SQL level string
ORA-22958: This operation is not allowed in check constraints or triggers
ORA-30102: 'string' is not in the legal range for 'string'
ORA-06135: NETTCP: connection rejected; server is stopping
ORA-09813: Unable to get directory status
ORA-25473: cannot store string in rule action context
ORA-32584: missing LOG keyword
ORA-32025: %s.string is not a table or view object.
DRG-11832: Request Entity Too Large
TNS-00110: Could not initialize network from file TNSNET.ORA
ORA-07223: slspool: fork error, unable to spawn spool process.
QSM-02034: no joins are present in the HAVING clause
Oracle Errors 
