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

RMAN-06085: must use SET NEWNAME command to restore datafile string

1 Answers  


ORA-16718: failed to locate the database resource

1 Answers  


ORA-08310: sllfop: Bad value for recsize

1 Answers  


QSM-00763: the owner string is invalid while validating user-defined workload string.string

1 Answers  


PCC-00029: Ambiguous option "string"

1 Answers  


KUP-02005: token too big

1 Answers  


SQL-02102: Inconsistent cursor cache. No global cursor entry.

1 Answers  


ORA-29538: Java not installed

1 Answers  


ORA-22807: cannot resolve to a scalar type or a collection type

1 Answers  


ORA-22954: This multiset operation is not supported for this element type.

1 Answers  


ORA-28551: pass-through SQL: SQL parse error

1 Answers  


ORA-12081: update operation not allowed on table "string"."string"

1 Answers  


Categories