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-00120: inappropriate argument in OPEN statement



PLS-00120: inappropriate argument in OPEN statement..

Answer / guest

Cause: The asterisk (*) option was used in the argument list
of a SQL group function other than COUNT. For example, the
code might look like SELECT SUM(*) INTO emp_count FROM emp;
-- should be COUNT(*) Only COUNT permits the use of the
asterisk option, which returns the number of rows in a table.

Action: Remove the asterisk option from the argument list
and replace it with an expression that refers to one or more
database columns.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-31428: no publication contains all the specified columns

1 Answers  


ORA-02069: global_names parameter must be set to TRUE for this operation

1 Answers  


RMAN-05502: the target database must be mounted when issuing a DUPLICATE command

1 Answers  


ORA-09282: sllfrb: error reading records

1 Answers  


RMAN-06565: WARNING: string: sqlcode number was caught, automatic retry #number

1 Answers  


ORA-01170: file not found 'string'

1 Answers  


QSM-01101: rollup(s) took place on mv, string

1 Answers  


NNL-00270: Current default domain is "string"

1 Answers  


ORA-37007: (AWLISTALL05) number writer

1 Answers  


ORA-02720: osnfop: shmat failed

1 Answers  


SQL*Loader-00263: PIECED column string must be last specified column in table string

1 Answers  


RMAN-08544: channel string: specifying archivelog(s) for proxy restore

1 Answers  


Categories