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

QSM-01079: DML operation occurred on a table referenced by MV, string

1 Answers  


ORA-39067: Unable to close the log file.

1 Answers  


PCB-00311: Datatype equivalencing is an Oracle extension

1 Answers  


PLS-00367: a RAISE statement with no exception name must be inside an exception handler

1 Answers  


ORA-32401: materialized view log on "string"."string" does not have new values

1 Answers  






TNS-00309: Connection Manager: Failed to open log while re-reading parameter data

1 Answers  


QSM-01083: query text not available - possible inline view

1 Answers  


PROC-00026: Error while accessing the physical storage

1 Answers  


NNL-00301: Server shutting down

1 Answers  


ORA-01299: dictionary string corresponds to a different database incarnation

1 Answers  


ORA-15070: maximum number of files string exceeded in diskgroup "string"

1 Answers  


ORA-06801: TLI Driver: listen for SPX server reconnect failed

1 Answers  


Categories