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 |
ORA-23335: priority group string already exists
NNL-01042: Data streams answered by server: number
RMAN-10008: could not create channel context
PLS-00629: PIPE statement cannot be used in non-pipelined functions
NCR-01007: NCRS: Operation is not supported in a given mode.
ORA-09983: skxfidsht: Error shutting down SDI channel
ORA-31652: command response message was invalid type - detaching job
ORA-00117: PROTOCOL, ADDRESS or DESCRIPTION must be specified
ORA-23342: invalid parameter column string
ORA-17619: max number of processes using I/O slaves in a instance reached
O2F-00337: Schema not found, or no types found in schema
ORA-40105: input data incompatible with model signature