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



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

Answer / guest

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

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-24316: illegal handle type

1 Answers  


AMD-00153: error detaching workspace "string"

1 Answers  


NZE-29195: CRL is expired

1 Answers  


O2I-00118: This user-defined type was not found in the database

1 Answers  


NZE-29004: Callback Failure

1 Answers  


ORA-13368: simple polygon type has more than one exterior ring

1 Answers  


RMAN-06595: platform name 'string' does not match database platform name 'string'

1 Answers  


ORA-10920: Cannot offline tablespace belonging to default temporary tablespace group

1 Answers  


TNS-12540: TNS:internal limit restriction exceeded

1 Answers  


ORA-23393: the user is already the propagator

1 Answers  


ORA-31641: unable to create dump file "string"

1 Answers  


ORA-14645: STORE IN clause cannot be specified for Range List objects

1 Answers  


Categories