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

LFI-00126: Record format can only be one of Fixed or Variable.

1 Answers  


ORA-16543: invalid request made to broker

1 Answers  


UDE-00007: attempt to free unallocated memory

1 Answers  


ORA-22857: cannot modify columns of object tables

1 Answers  


RMAN-06433: error installing recovery catalog

1 Answers  






NZE-29044: Renegotiation has already been requested.

1 Answers  


ORA-22909: exceeded maximum VARRAY limit

1 Answers  


RMAN-06745: skipping datafilecopy string; already backed up string time(s)

1 Answers  


NNC-00412: invalid name "string"

1 Answers  


PLS-00251: RETURN, for actual function return, must be last in the parameters clause

1 Answers  


TNS-00216: Total Failed Connections : number

1 Answers  


ORA-30503: system triggers cannot have a REFERENCING clause

1 Answers  


Categories