Oracle DBA, How To, Error, Cause and Action

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