PLS-00702: second argument to PRAGMA EXCEPTION_INIT must be a numeric literal

PLS-00702: second argument to PRAGMA EXCEPTION_INIT must be a numeric literal
Cause: The second argument passed to an EXCEPTION_INIT pragma was something other than a numeric literal (a variable, for example). The second argument must be a numeric literal in the range -9999 .. -1 (excluding -100) for Oracle errors or in the range -20000 .. -20999 for user-defined errors.
Action: Replace the second argument with a valid error number.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00702：PRAGMA EXCEPTION_INIT的第二个参数必须是数字字面值,
.原因：传递给EXCEPTION_INIT编译指示的第二个参数是数字字面值（例如变量）之外的其他参数。对于Oracle错误，第二个参数必须是-9999 .. -1（不包括-100）范围内的数字文字，或者对于用户定义的错误，范围为-20000 .. -20999。,
.操作：用有效的错误号替换第二个参数。,
.

aiaiDBA

13718043309

010-86462881

PLS-00702: second argument to PRAGMA EXCEPTION_INIT must be a numeric literal

1 个回答

相似问题