audit drop procedure; fails with ORA-00956

From: Ethan Post <>
Date: Fri, 21 Aug 2009 09:19:57 -0500
Message-ID: <>

SQL> audit create procedure
Audit complete.
SQL> audit create any procedure
Audit complete.
SQL> audit drop any procedure
Audit complete.
  • Why does this fail? Isn't this just the opposite of CREATE PROCEDURE. It is listed in the exact same section of the docs as CREATE PROCEDURE, I would think the syntax is the same.

SQL> audit drop procedure
audit drop procedure
Error at line 9
ORA-00956: missing or invalid auditing option

-- Received on Fri Aug 21 2009 - 09:19:57 CDT

Original text of this message