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

Translate this page

Oracle Database Error ORA-01984

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

User Posts for ORA-01984

Jul242017

Susan RosarioI don’t know why the software Oracle data base is giving so many problems. As I have faced this one too on my system. But thanks, bro you made this issue easy for us to resolve master assignment. I just love the description you have written here about this error. Thanks for helping all of us.

Post your own questions, answers and tips for ORA-01984

No registration required

CAPTCHA Image New word