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-00826: cannot set sga_target for an ASM instance

1 Answers  


EXP-00066: Object table string is missing its object identifier index

1 Answers  


ORA-00100: no data found

1 Answers  


ORA-38738: Flashback log file is not current copy.

1 Answers  


AMD-00150: Custom Measure to delete "string" not mapped to View "string"

1 Answers  






QSM-00761: the priority string is invalid for the current operation

1 Answers  


ORA-39951: incomplete values specified for PL/SQL warning settings

1 Answers  


ORA-31019: Recursive deletion snapshot too old for string/string

1 Answers  


ORA-26517: materialized view control entry for 'string.string' was not found

1 Answers  


ORA-07476: slsget: cannot get mapped memory statistics.

1 Answers  


SQL*Loader-00119: Invalid parallel file (data file) name on command line

1 Answers  


ORA-24127: TABLESPACE parameter specified with an ACTION other than CREATE_ACTION

1 Answers  


Categories