aiaiDBA

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

13718043309

010-86462881

PLW-05005: subprogram string returns without value at line string

PLW-05005: subprogram string returns without value at line string
Cause: A function terminated without a return value. RETURN statements with values are required for all PL/SQL functions.
Action: Inspect function source code to ensure that every RETURN statement returns a value and that a function does not terminate by executing its END statement. Notice that this message may appear at the call site for a function if the function call was inlined and if the called function did not terminate properly.

请先 登录 后评论

1 个回答

小智
PLW-05005:子程序字符串返回没有值的行字符串,
.原因:一个函数在没有返回值的情况下终止。具有值的RETURN语句对于所有PL / SQL函数都是必需的。,
.操作:检查函数源代码以确保每个RETURN语句返回一个值,并且函数不会通过执行其END语句来终止。请注意,如果函数调用是内联的,并且被调用函数没有正确终止,则此消息可能会出现在函数的调用站点。,
.
请先 登录 后评论