PLS-00640: a pipelined function cannot be called from PL or SQL context

PLS-00640: a pipelined function cannot be called from PL or SQL context

Cause: A pipelined function was invoked from a PL or SQL expression.

Action: Use the pipelined function in the FROM clause of a SQL query.