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-01261: Parameter string destination string cannot be translated
PCC-00119: Value of const variable in INTO clause will be modified
NZE-28761: element creation failure
ORA-06022: NETASY: channel open failure
TNS-12212: TNS:incomplete PREFERRED_CMANAGERS binding in TNSNAV.ORA
ORA-29296: invalid encoded string
ORA-07485: scg_get_inst: cannot open instance number lock.
ORA-13417: null or invalid layerNumber for get functions
LPX-00315: extension function ~S not supported
ORA-22951: NULL returned by ORDER method
PLS-00543: a PLSQL Table may not contain a nested table type or VARRAY.
TNS-12690: Server Authentication failed, login cancelled