Cause: The caller of a pipelined function does not need more rows to be produced by the pipelined function. See the solution below.
Error solution: Catch the NO_DATA_NEEDED exception is an exception handling block.
Database version: Oracle 11g Release 2 (11.2)