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

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

Question Posted / guest

1 Answers
5022 Views
I also Faced
E-Mail Answers

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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?

0 Yes

0 No

Post New Answer