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