Oracle Error PLS-00120: inappropriate argument in OPEN statement

Oracle Error Message

PLS-00120: inappropriate argument in OPEN statement

Reason for the Error

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.

Solution

Remove the asterisk option from the argument list and replace it with an expression that refers to one or more database columns.