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-12082: "string"."string" cannot be index organized

1 Answers  


PLS-00304: cannot compile body of 'string' without its specification

1 Answers  


ORA-12029: LOB columns may not be used as filter columns

2 Answers  


ORA-01509: specified name 'string' does not match actual 'string'

1 Answers  


ORA-30347: a table name is required to qualify the column specification

1 Answers  






ORA-36683: (XSDPART21) Partition string dimensioned by more than one composite.

1 Answers  


NZE-28865: SSL connection closed

1 Answers  


ORA-29960: line string, string

1 Answers  


ORA-31448: invalid value for change_source

1 Answers  


PCC-00077: Colon usage with numeric label in WHENEVER statement is not ANSI

1 Answers  


ORA-02067: transaction or savepoint rollback required

1 Answers  


ORA-12549: TNS:operating system resource quota exceeded

1 Answers  


Categories