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-06979: X.25 Driver: server cannot start oracle

1 Answers  


QSM-02078: mv log must have new values

1 Answers  


SQL*Loader-00259: Could not escalate DDL share lock to exclusive on table string

1 Answers  


PLS-00588: unqualified instance attribute references allowed only in member methods

1 Answers  


ORA-25153: Temporary Tablespace is Empty

1 Answers  


DGM-16933: Unable to start instance "string".

1 Answers  


ORA-07425: sdpri: error string in translating dump file location.

1 Answers  


ORA-16733: Error executing dbms_logstdby.unskip procedure

1 Answers  


SQL*Loader-00802: numeric EXTERNAL with DEFAULTIF clause not supported by External Table

1 Answers  


ORA-12341: maximum number of open mounts exceeded

1 Answers  


ORA-00032: invalid session migration password

1 Answers  


NNL-00896: Requests refused, modifications disabled: number

1 Answers  


Categories