PLS-00503: RETURN statement required for this return from function

PLS-00503: RETURN <value> statement required for this return from function

PLS-00503: RETURN statement required for this return from function
Cause: In a function body, a RETURN statement was used that contains no expression. In procedures, a RETURN statement contains no expression because the statement simply returns control to the caller. However, in functions, a RETURN statement must contain an expression because its value is assigned to the function identifier.
Action: Add an expression to the RETURN statement.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00503：返回从函数返回的语句,
.原因：在函数体中，使用不包含表达式的RETURN语句。在过程中，RETURN语句不包含表达式，因为该语句只是将控制权返回给调用者。但是，在函数中，RETURN语句必须包含一个表达式，因为它的值分配给函数标识符。,
.操作：将表达式添加到RETURN语句。,
.

aiaiDBA

13718043309

010-86462881

PLS-00503: RETURN <value> statement required for this return from function

1 个回答

相似问题