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

PLS-00134: Pragma string expects 2nd argument to be an identifier or string-literal

1 Answers  


RMAN-06079: database must be mounted to perform recovery

1 Answers  


PLS-00950: In this version, PL/SQL tables can not be used in this SQL statement.

1 Answers  


NNO-00069: warning: too many administrative region check failures, checking disabled

1 Answers  


ORA-01578: ORACLE data block corrupted (file # string, block # string)

1 Answers  


ORA-19551: device is busy, device type: string, device name: string

1 Answers  


DRG-11724: phrase string already exists

1 Answers  


ORA-16098: inaccessible standby database forced shutdown to protect primary

1 Answers  


SQL*Loader-00103: Invalid log file name on command line

1 Answers  


PLS-00361: IN cursor 'string' cannot be OPEN'ed

1 Answers  


NNL-00801: Queries received, type ANY: number

1 Answers  


ORA-22063: reading negative value [string] as unsigned

1 Answers  


Categories