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-31088: object "string"."string" depends on the schema

1 Answers  


O2F-00302: Unable to allocate memory

1 Answers  


ORA-07214: slgunm: uname error, unable to get system information.

1 Answers  


ORA-08341: On nCUBE, this command can only be executed from instance 1.

1 Answers  


ORA-30101: unknown parameter name 'string'

1 Answers  


RMAN-03038: Spooling started in trace file: string

1 Answers  


ORA-30434: refresh method must be one of FC?AN, not 'string'

1 Answers  


ORA-00018: maximum number of sessions exceeded

1 Answers  


ORA-27372: length of action and arguments exceeds platform limit string

1 Answers  


ORA-01672: controlfile may be missing files or have extra ones

1 Answers  


LSX-00210: value "~1S" out of range for type "~2S"

1 Answers  


ORA-14279: index mismatch for tables in ALTER TABLE EXCHANGE SUBPARTITION

2 Answers  


Categories