PLS-00121: only the set function COUNT may take * as an argument

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.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/