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 |
NZE-29246: the toolkit could not parse the tdu
ORA-27488: unable to set string because string was/were already set
ORA-12002: there is no materialized view log on table "string"."string"
KUP-04056: internal error: OCI error while fetching record: number
DRG-12232: invalid attribute tag format
ORA-32059: deadlock detected on mapping structures
SQL*Loader-00939: OCI error while string for table string partition string
ORA-14517: subpartition of index 'string.string' is in unusable state
DRG-11810: Partial Update OK
ORA-09320: szrfc: unable to obtain the list of valid OS roles
NNF-04000: File succesfully converted
LPX-00209: PI names starting with XML are reserved