PLS-00372: In a procedure, RETURN statement cannot contain an expression

PLS-00372: In a procedure, RETURN statement cannot contain an expression
Cause: In a procedure, a RETURN statement contains an expression, which is not allowed. In functions, a RETURN statement must contain an expression because its value is assigned to the function identifier. However, in procedures, a RETURN statement simply lets you exit before the normal end of the procedure is reached.
Action: Remove the expression from the RETURN statement, or redefine the procedure as a function.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00372：在一个过程中，RETURN语句不能包含表达式,
.原因：在一个过程中，RETURN语句包含不允许的表达式。在函数中，RETURN语句必须包含一个表达式，因为它的值分配给函数标识符。但是，在过程中，RETURN语句只是让您在达到正常程序结束之前退出。,
.操作：从RETURN语句中删除表达式，或将该过程重新定义为函数。,
.

aiaiDBA

13718043309

010-86462881

PLS-00372: In a procedure, RETURN statement cannot contain an expression

1 个回答

相似问题