In this post, you’ll learn more about the Oracle ErrorPLS-00655: only functions can be declared as PIPELINED with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
PLS-00655: only functions can be declared as PIPELINED
Reason for the Error PLS-00655: only functions can be declared as PIPELINED
user is trying to declare a procedure to be pipeliend function
How to fix the Error PLS-00655: only functions can be declared as PIPELINED ?
You can fix this error in Oracle by following the below steps
declare a function instead of a procedure to be a pipelined function