Oracle Error PLS-00126: selector ALL is not allowed

Oracle Error Message

PLS-00126: selector ALL is not allowed

Reason for the Error

The ALL shortcut for specifying system privileges or statement options was used in a SQL statement. PL/SQL does not support the ALL shortcut.

Solution

Remove the ALL shortcut from the SQL statement.