错误码 / Oracle Database

Oracle Database 错误码 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 exampl…

错误说明

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.

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

官方文档

进一步检索

相关错误码