In this post, you’ll learn more about the Oracle ErrorORA-01984: invalid auditing option for procedures/packages/functions with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-01984: invalid auditing option for procedures/packages/functions
Reason for the Error ORA-01984: invalid auditing option for procedures/packages/functions
AUDIT or NOAUDIT on a DEFAULT specifies an auditing option that is not legal for procedures, packages, or functions.
How to fix the Error ORA-01984: invalid auditing option for procedures/packages/functions ?
You can fix this error in Oracle by following the below steps
The following options may not be used for procedures, packages, and functions and should be removed: all but EXECUTE