Oracle Solution for Error ora-01984
ORA-01984: invalid auditing option for procedures/packages/functions
What triggered the Error:
AUDIT or NOAUDIT on a DEFAULT specifies an auditing option that is not legal for procedures, packages, or functions.What should we do to fix it:
The following options may not be used for procedures, packages, and functions and should be removed: all but EXECUTE
If this was not sufficient go over to:
Oracle Official Support Knowledge Center
Or maybe those geeks at: StackOverflow Board
Or maybe those geeks at: StackOverflow Board
