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 |
ORA-13782: The specified user "string" does not exist.
RMAN-06424: error while looking up proxy copy
PCC-00029: Ambiguous option "string"
NNL-00981: Timeouts, server not responding: number
IMG-00516: default channel out of range
ORA-14163: subpartition number string: INITRANS value must be less than MAXTRANS value
ORA-28506: parse error in data dictionary translation for string stored in string
ORA-02169: FREELISTS storage option not allowed
ORA-39064: unable to write to the log file
ORA-02151: invalid tablespace name: string
PCC-02319: expression type does not match usage
ORA-24907: invalid pair of callback and recepient protocol attributes