Oracle Error ORA-48222: Predicates/Order By Not Allowed

Oracle Error Message

ORA-48222: Predicates/Order By Not Allowed

Reason for the Error

A predicate or order by can not be added after fetch has started.

Solution

Put the predicate or order by call before the first fetch.