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-00326: IN clause must contain same number of expressions
as subquery

Answer Posted / guest

Cause: The number of expressions in an IN clause did not
equal the number of expressions in a corresponding subquery
select list. For example, the following statement is invalid
because the IN clause contains two expressions, but the
subquery select list contains just one: ... WHERE (ename,
sal) IN (SELECT sal FROM emp);

Action: Check the number of expressions in each set, then
revise the statement to make the numbers equal.

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

when i ran any workflow or session, getting below error: seesion task instance[s_xxx]: Execution terminated unexpecterdly

2175


NZE-28890: Entrust Login Failed

1812


ORA-26076: cannot set or reset value after direct path structure is allocated

1903


ORA-26095: unprocessed stream data exists

3515


IMG-02003: 2FF03 - incorrect color histogram feature specification

1655


In my project I am using star schema and only diimension tables are loaded and not fact tables any one can help me why it is happening? Plase guide me.

2803


ORA-26030: index string.string had string partitions made unusable due to:

1896


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

8758


NZE-28868: Peer certificate chain check failed.

2746


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

1704


ORA-07497: sdpri: cannot create trace file 'string'; errno = string.

2745


ORA-16626: failed to enable specified object

2159


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

2098


ORA-26082: load of overlapping segments on table string.string is not allowed

1719


IMP-00064: Definition of LOB was truncated by export

6350