Oracle Error PLS-00640: a pipelined function cannot be called from PL/SQL context

Oracle Error Message

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

Reason for the Error

A pipelined function was invoked from a PL/SQL expression.

Solution

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