PLS-00396: INSERT statement's subquery yields wrong number
of columns
- 1 Answers
- 2899 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-31164: cannot load object-relational XML attribute using direct path
ORA-32830: result code string returned by Messaging Gateway agent
ORA-00981: cannot mix table and system auditing options
ORA-03202: the scan limit specification is invalid
ORA-16110: user procedure processing of logical standby apply DDL
ORA-16012: Archive log standby database identifier mismatch
PLS-00924: native compilation is not supported on this platform
ORA-25147: UNIFORM SIZE value greater than maximum extent size
ORA-02474: Fixed hash area extents used (string) exceeds maximum allowed (string)
ORA-31453: invalid value string for parameter, expecting: Y, N, or NULL
RMAN-06119: uncataloged datafile copy
CLSR-00515: A service member is already running on this node
Oracle Errors 
