Oracle Error PLS-00629: PIPE statement cannot be used in non-pipelined functions

Oracle Error Message

PLS-00629: PIPE statement cannot be used in non-pipelined functions

Reason for the Error

A PIPE statement was used in a non-pipelined function.

Solution

Use PIPE statement only in pipelined functions.