Database Error Messages

PLS-00778

PARTITION BY, ORDER BY, CLUSTER BY, or PARALLEL_ENABLE are not allowed for SQL macros

Action

Do not specify PARTITION BY, CLUSTER BY, ORDER BY, DETERMINISTIC, AUTHID, or PARALLEL_ENABLE clause with a SQL macro.