How to fix the Oracle error PLS-00126: selector ALL is not allowed?

In this post, you’ll learn more about the Oracle ErrorPLS-00126: selector ALL is not allowed with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PLS-00126: selector ALL is not allowed

Reason for the Error PLS-00126: selector ALL is not allowed

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

How to fix the Error PLS-00126: selector ALL is not allowed ?

You can fix this error in Oracle by following the below steps

Remove the ALL shortcut from the SQL statement.