Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

ORA-16627: No standby databases support the overall protection mode.

3984


NZE-28868: Peer certificate chain check failed.

2797


[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

2719


ORA-26079: file "string" is not part of table string.string

1955


IMP-00070: Lob definitions in dump file are inconsistent with database.

1741


invalid quantity specification negative quantity are not allowed for this item please check this item definition quantity

3381


ORA-26028: index string.string initially in unusable state

3858


NZE-28890: Entrust Login Failed

1872


IMP-00096: Warning: Skipping table "string"."string" because type synonym "string"."string" cannot be created

1616


ORA-26029: index string.string partition string initially in unusable state

2152


ORA-26027: unique index string.string partition string initially in unusable state

6742


ORA-26032: index string.string loading aborted after string keys

2103


ORA-16626: failed to enable specified object

2211


ORA-16516: The current state is invalid for the attempted operation.

8813


ORA-26094: stream format error: input column overflow

2794