Hi everybody,
My purpose is to audit the execution of a specified procedure, function in a package. So I try this audit option
audit execute on dbms_java.longname
Althought I'm using SYS, it leads to this error:
SQL Error: ORA-00942: table or view does not exist
00942. 00000 - "table or view does not exist"
But when I try
audit execute on dbms_java
It's ok and it audit every statement that using that package dbms_java. But thing I want is audit the specified procedure on this package, not all of this package.
Also, I wonder why DBA_OBJ_AUDIT_OPTS show DBMS_JAVA package object type is procedure ???