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

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


Cause:


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



Action:


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