PLS-00230: OUT and IN OUT formal parameters may not have default expressions

PLS-00230: OUT and IN OUT formal parameters may not have default expressions
Cause: When the formal parameters of a procedure were declared, an OUT or IN OUT parameter was initialized to a default value, as in PROCEDURE calc_bonus (bonus OUT REAL := 0, ...) IS ... However, only IN parameters can be initialized to default values.
Action: Remove the illegal default expression.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00230：OUT和IN OUT格式参数可能没有默认表达式,
.原因：当程序的形式参数被声明时，OUT或IN OUT参数被初始化为默认值，如PROCEDURE calc_bonus（bonus OUT REAL：= 0，...）IS ...但是，只有IN参数可以初始化为默认值。,
.操作：删除非法的默认表达式。,
.

aiaiDBA

13718043309

010-86462881

PLS-00230: OUT and IN OUT formal parameters may not have default expressions

1 个回答

相似问题