PLS-00396: INSERT statement's subquery yields wrong number
of columns
- 1 Answers
- 2918 Views
- I also Faced
- E-Mail Answers
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-06141: NETTCP: no privilege for user
ORA-14095: ALTER TABLE EXCHANGE requires a non-partitioned, non-clustered table
ORA-02269: key column cannot be of LONG datatype
ORA-01070: Using an old version of Oracle for the server
ORA-16603: Data Guard broker detected a mismatch in configuration ID.
TNS-04046: Invalid specification for source
TNS-00138: Failed to find ORACLE executable directory
ORA-14011: names assigned to resulting partitions must be distinct
TNS-01114: LSNRCTL could not perform local OS authentication with the listener
NNL-00870: Update requests received: number
ORA-27067: size of I/O buffer is invalid
ORA-13856: Service name must be specified
Oracle Errors 
