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

IMP-00063: Warning: Skipping table "string"."string" because object type "string"."string" cannot be created or has different identifier

0 Answers  


ORA-13364: layer dimensionality does not match geometry dimensions

1 Answers  


ORA-30071: conversion between datetime/interval and string fail

1 Answers  


ORA-01126: database must be mounted in this instance and not open in any instance

1 Answers  


ORA-10638: Index status is invalid

1 Answers  






ORA-30333: dimension does not exist

1 Answers  


LFI-01507: fwrite() failed(OSD return value = string) in string.

1 Answers  


ORA-07417: sfareq: One or more database writers not active.

1 Answers  


ORA-32123: Attribute number is out of range

1 Answers  


DRG-11710: thesaurus term string too long

1 Answers  


NNL-00918: Time until server restart: string

1 Answers  


ORA-00037: cannot switch to a session belonging to a different server group

1 Answers  


Categories