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

IMG-00603: unable to access source image data

1 Answers  


PCC-00090: Precision/scale specification must be given for DECIMAL datatype

1 Answers  


DRG-10837: section string does not exist

1 Answers  


ORA-01293: mounted database required for specified LogMiner options

1 Answers  


LPX-00244: invalid use of less-than ('<') character (use <)

1 Answers  


DRG-12511: use ctx_ddl.create_stoplist to create stoplists

1 Answers  


TNS-00022: INTCTL: missing CMANAGER_NAME in INTCHG.ORA

1 Answers  


UDI-00050: unable to setup parameter processing.

1 Answers  


ORA-10915: TABLESPACE GROUP cannot be specified for this type of tablespace

1 Answers  


ORA-34489: (MXMAINT06) You cannot maintain workspace object because it is a SURROGATE.

1 Answers  


ORA-37004: (AWLISTALL02) number reader

1 Answers  


PCC-00028: Option "string" not legal as EXEC ORACLE OPTION

1 Answers  


Categories