Showing posts with label ORA-01984: invalid auditing option for procedures or packages or functions. Show all posts
Showing posts with label ORA-01984: invalid auditing option for procedures or packages or functions. Show all posts

Friday, 20 January 2012

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

ORA-01984: invalid auditing option for procedures or packages or 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