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-16400: quota attributes are not allowed with DB_RECOVERY_FILE_DEST

1 Answers  


ORA-34286: (MXDCL53) workspace object cannot be used in this context because it is a string.

1 Answers  


PLS-00590: attempting to create a subtype UNDER a FINAL type

1 Answers  


EXP-00046: Tablespace named string does not exist

1 Answers  


ORA-06421: NETCMN: Error detected in the read-in data

1 Answers  






ORA-16551: short string copied

1 Answers  


TNS-01153: Failed to process string: string

1 Answers  


SQL*Loader-00410: Number to skip must be load-level, not table-level

1 Answers  


TNS-12234: TNS:Redirect to destination

1 Answers  


ORA-07222: slspool: line printer spooler command exited with an error.

1 Answers  


ORA-35074: (QFHEAD02) EIF file string cannot be read by this version of string.

1 Answers  


PCC-01513: FIPS warning: Unsupported datatype in line number of file string

1 Answers  


Categories