Hi everybody,
I want to audit execution of a function in package, but the document said that can't specify a function in package to audit, so I have to add an audit option for execution of to the whole package:
Audit execute on sys.dbms_java by access
After that, I use another user to execute this:
select dbms_java.runjava('oracle/aurora/util/Test') from dual
It's ok, one audit record generated. But when I try to execute this statement again many times, no record generated. Then I try to create new session for this user and execute again, one audit record is generated and when execute again, no record generated. Then I try to change the audit option to 'by session' but nothing happen.
I'm so confused. Can anyone explain me ?