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-24775: cannot prepare or commit transaction with non-zero lock value

1 Answers  


NID-00602: Could not allocate number bytes for "string"

1 Answers  


ORA-29251: Index1 is greater than Index2 in call to dbms_sql.bind_array

1 Answers  


ORA-14603: [SUBPARTITIONS | SUBPARTITION TEMPLATE] subpartition_count syntax is valid only for range-hash tables

1 Answers  


RMAN-08589: channel string: starting datafile conversion

1 Answers  


ORA-02347: cannot grant privileges on columns of an object table

1 Answers  


ORA-23403: refresh group "string"."string" already exists

1 Answers  


PLS-00210: an OTHERS clause is required in this CASE statement

1 Answers  


ORA-19720: Error occurred when converting an OCI number into an SCN

1 Answers  


LFI-00006: Invalid parameter to function string.

1 Answers  


LPX-00253: missing required version number in XML declaration

1 Answers  


ORA-13862: Statistics aggregation for client identifier string is not enabled

1 Answers  


Categories