PLS-00398: wrong number of columns in UNION, INTERSECT, or
MINUS expression
Answer / guest
Cause: The SELECT clauses to the left and right of a UNION,
INTERSECT, or MINUS expression do not select the same number
of columns. For example, the following statement is faulty
because the select lists do not contain the same number of
items: CURSOR my_cur IS SELECT ename FROM emp INTERSECT
SELECT ename, empno FROM emp;
Action: Change the select lists so that they contain the
same number of items.
Please add more information about this Error
| Is This Answer Correct ? | 1 Yes | 0 No |
PLS-00612: Number of attributes do not match in SET clause
ORA-13136: null common code generated
LPX-00002: out of memory
ORA-28526: invalid describe information returned to Heterogeneous Services
ORA-31652: command response message was invalid type - detaching job
DRG-10821: contains cursor is not open
PLS-00737: LIBRARY file specification exceeds the maximum allowed length
DRG-11005: invalid create index parameter string
ORA-36995: (XSRELGID12) There are duplicate values in the surrogate dimension gid. Use the levelorder option to resolve the ambiguity.
ORA-19730: can not convert offline plugged-in datafile string
ORA-00382: %s not a valid block size, valid range [string..string]
ORA-01246: recovering files through TSPITR of tablespace string