Oracle Error PLS-00654: PARTITION/ORDER/CLUSTER BY are allowed for only with PARALLEL_ENABLE

Oracle Error Message

PLS-00654: PARTITION/ORDER/CLUSTER BY are allowed for only with PARALLEL_ENABLE

Reason for the Error

User tried partion by order by cluster by without parallel enable clause in table function.

Solution

specify parallel enable also when using partion by, cluster by order by clause.