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