PLS-00396: INSERT statement's subquery yields wrong number
of columns
- 1 Answers
- 3271 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-09241: smsalo: error allocating SGA memory
ORA-12623: TNS:operation is illegal in this state
ORA-16562: intended_state not used here, syntax error at "string"
DRG-11522: no row exists for the text key(s) specified
PLS-00208: identifier 'string' is not a legal cursor attribute
DRG-52104: the Oracle Text environment could not initialize
ALTER TABLE JAFAR_BIZREN_REDUMPTION_DATA1 RENAME COLUMN DROP_POINT TO DEPOT_ID
VID-00703: unable to read video data
ORA-25243: CONSUMER_NAME cannot be specified when dequeuing from exception queue string.string
ORA-28264: Client identifier is too long
ORA-16726: the external condition supplied to resource manager is invalid
ORA-02337: not an object type column
Oracle Errors 
