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.

No comments:

Post a Comment