How to fix the Oracle error PLS-00120: inappropriate argument in OPEN statement?

In this post, you’ll learn more about the Oracle ErrorPLS-00120: inappropriate argument in OPEN statement with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PLS-00120: inappropriate argument in OPEN statement

Reason for the Error PLS-00120: inappropriate argument in OPEN statement

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.

How to fix the Error PLS-00120: inappropriate argument in OPEN statement ?

You can fix this error in Oracle by following the below steps

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