PLS-00396: INSERT statement's subquery yields wrong number
of columns
Answer / guest
Cause: The number of columns in an INSERT statement does not
match the number of columns in a subquery select list. For
example, the following statement is faulty because no
corresponding column is specified for col3: INSERT INTO emp
(ename, empno) SELECT col1, col2, col3 FROM ...
Action: Change the number of items in the column list of the
INSERT statement or the number of items in the select list
so that the numbers match.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 2 No |
IMG-00544: invalid compressionQuality specified
NID-00106: LOGIN to target database failed with Oracle error: string
DRG-51202: invalid key mapping operation mode : string
SQL*Loader-00430: NULL nested table element is not allowed
RMAN-08102: channel string: located backup piece: string
ORA-02310: exceeded maximum number of allowable columns in table
PROC-00013: Cannot perform cluster registry operation because one of the parameters is NULL.
ORA-02476: can not create index due to parallel direct load on table
QSM-00768: the search condition is invalid for the requested operation
ORA-12817: parallel query option must be enabled
ORA-13364: layer dimensionality does not match geometry dimensions
ORA-02797: No requests available