PLS-00406: length of SELECT list in subquery must match
number of assignment targets
Answer Posted / guest
Cause: A query select list is not the same length as the
list of targets that will receive the returned values. For
example, the following statement is faulty because the
subquery returns two values for one target: UPDATE emp SET
ename = (SELECT ename, empno FROM emp WHERE ename = 'SMITH') ...
Action: Change one of the lists so that they contain the
same number of items.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
ORA-16627: No standby databases support the overall protection mode.
NZE-28868: Peer certificate chain check failed.
[ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) Unsuccessful: alter table user.CEN_USER_MASTER add constraint FKF4EDEDC3D0BAAE75 foreign key (ROLE_ID) references user.CEN_ROLE_MASTER [ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) ORA-02275: such a referential constraint already exists in the table
ORA-26079: file "string" is not part of table string.string
IMP-00070: Lob definitions in dump file are inconsistent with database.
invalid quantity specification negative quantity are not allowed for this item please check this item definition quantity
ORA-26028: index string.string initially in unusable state
NZE-28890: Entrust Login Failed
IMP-00096: Warning: Skipping table "string"."string" because type synonym "string"."string" cannot be created
ORA-26029: index string.string partition string initially in unusable state
ORA-26027: unique index string.string partition string initially in unusable state
ORA-26032: index string.string loading aborted after string keys
ORA-16626: failed to enable specified object
ORA-16516: The current state is invalid for the attempted operation.
ORA-26094: stream format error: input column overflow