PLS-00633: RETURN statement in a pipelined function cannot contain an expression

PLS-00633: RETURN statement in a pipelined function cannot contain an expression
Cause: A RETURN statement in a pipelined function contains an expression, which is not allowed. Pipelined functions must send back values to the caller by using the PIPE statement.
Action: Remove the expression from the RETURN statement and use a PIPE statement to return values. Else, convert the function into a non-pipelined function.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00633：流水线函数中的RETURN语句不能包含表达式,
.原因：流水线函数中的RETURN语句包含不允许的表达式。流水线函数必须使用PIPE语句将值发送给调用者。,
.操作：从RETURN语句中删除表达式，并使用PIPE语句返回值。否则，将功能转换为非流水线功能。,
.

aiaiDBA

13718043309

010-86462881

PLS-00633: RETURN statement in a pipelined function cannot contain an expression

1 个回答

相似问题