Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

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.