aiaiDBA

加微信获取免费职业规划+学习资料,了解年薪50万的DBA是如何练成的

13718043309

010-86462881

PLS-00120: inappropriate argument in OPEN statement

PLS-00120: inappropriate argument in OPEN statement
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.

请先 登录 后评论

1 个回答

小智
PLS-00120:OPEN语句中的不正确参数,
.原因:在除COUNT之外的SQL组函数的参数列表中使用了星号(*)选项。例如,代码可能看起来像SELECT SUM(*)INTO emp_count FROM emp; - 应该是COUNT(*)只有COUNT允许使用星号选项,返回表中的行数。,
.操作:从参数列表中删除星号选项,并将其替换为引用一个或多个数据库列的表达式。,
.
请先 登录 后评论