Oracle Error ORA-01984: invalid auditing option for procedures/packages/functions

Oracle Error Message

ORA-01984: invalid auditing option for procedures/packages/functions

Reason for the Error

AUDIT or NOAUDIT on a DEFAULT specifies an auditing option that is not legal for procedures, packages, or functions.

Solution

The following options may not be used for procedures, packages, and functions and should be removed: all but EXECUTE