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-12912: Dictionary managed tablespace specified as temporary tablespace

1 Answers  


QSM-02066: Oracle error: see RELATED_NUM and RELATED_TEXT for details

1 Answers  


ORA-36728: (XSALERR01) While performing the ALLOCATE command with AGGMAP workspace object, the error logging limit of number was exceeded.

1 Answers  


ORA-22153: source variable-length array is not initialized

1 Answers  


PCB-00232: Tables not allowed as input bind variables in SELECT statement

1 Answers  


ORA-13504: No SYSAUX datafile clause specified

1 Answers  


ORA-09314: sltln: error translating logical name

1 Answers  


NNL-00013: not performed, permission denied for supplied password

1 Answers  


ORA-25470: duplicate attribute value for variable: string

1 Answers  


ORA-12677: Authentication service not supported by database link

1 Answers  


NNL-00569: domain_hint <domain_name> <NS_name> <NS_Addr> : Provide hint of a nameserver for a given domain

1 Answers  


DRG-11612: URL store: unknown host specified in string

1 Answers  


Categories