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-24316: illegal handle type

1 Answers  


ORA-07241: slemrd: read error.

1 Answers  


RMAN-06035: wrong version of recover.bsq, expecting string, found string

2 Answers  


NNL-00218: Ignoring spurious trailing text "string"

1 Answers  


ORA-09261: spdcr: error creating detached (background) process

1 Answers  


LSX-00010: extra element(s) at end of "~S"

1 Answers  


ORA-14312: Value string already exists in partition string

1 Answers  


ORA-23384: replication parallel push string argument out of range

1 Answers  


ORA-22055: unknown sign flag value [string]

1 Answers  


ORA-19761: block size string is not valid for change tracking file

1 Answers  


ORA-16407: Standby database is in the future of the archive log

1 Answers  


QSM-02038: Partition Change Tracking (PCT) is enabled

1 Answers  


Categories