PLS-00665: ORDER BY and CLUSTER BY clauses require a PARTITION BY clause

PLS-00665: ORDER BY and CLUSTER BY clauses require a PARTITION BY clause

Cause: An attempt was made to specify an ORDER BY or CLUSTER BY clause without also specifying a PARTITION BY clause.

Action: Add a PARTITION BY clause, or remove the ORDER BY or CLUSTER BY clause.