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-06707: TLI Driver: connection failed

1 Answers  


NNL-00413: Total response time: string

1 Answers  


ORA-13356: adjacent points in a geometry are redundant

1 Answers  


ORA-30396: rewrite equivalence procedures require the COMPATIBLE parameter to be string or greater

1 Answers  


TNS-00116: Pump failed during initial bequeath

1 Answers  


ORA-30055: NULL snapshot expression not allowed here

1 Answers  


LSX-00111: type "~S" contains invalid facets

1 Answers  


ORA-23608: invalid resolution column "string"

1 Answers  


ORA-27041: unable to open file

1 Answers  


RMAN-06900: WARNING: unable to generate V$RMAN_STATUS or V$RMAN_OUTPUT row

1 Answers  


SQL*Loader-00561: end of file

1 Answers  


SQL*Loader-00948: subpartition string not part of table string

1 Answers  


Categories