Oracle Error PLS-00655: only functions can be declared as PIPELINED

Oracle Error Message

PLS-00655: only functions can be declared as PIPELINED

Reason for the Error

user is trying to declare a procedure to be pipeliend function

Solution

declare a function instead of a procedure to be a pipelined function