Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Audit Packages and Procedures -- Help With dependencies

882742Aug 16 2011 — edited Aug 18 2011
Hello, I would like to help on a problem I have in oracle.

well, actually we have a project where we need to perform a certain audit certain database objects to identify who was responsible for the change and the reason for the change. for that we had the idea of making the creation of a trigger event in the compilation of all objects, but at the time of the audit we face a problem of identification of the object, I know that you can identify the compiled object using the command ORA_DIST_OBJ, but I can not identify which object was the first compiled since the trigger is fired for each of the dependencies recompiled automatically by Oracle. Exemplifying.:

I have the following objects
-> Package PC_OBJECT1.PR_OBJECT_GRANDFATHER
-> Package PC_OBJECT1.PR_OBJECT_FACHER
-> Package PC_OBJECT1.PR_OBJECT_SON
-> Package PC_OBJECT1.PR_OBJETO_GRANDSON

Being the grandson of the child dependency, which is a dependency of his father, who is the grandfather dependence, I want to monitor in this situation allways when the compilation of the parent object occur , but I only want to know when the changed object and the compile occur (which the User execute the compiler command) on the parent object itself. Don't need to store information when the object is compiled because the GRANDFATHER object has been compiled and the father object as a dependency has been compiled too. Is there any way to know that!? what is the object that actually received the command of compile and that was not compiled because he was dependent!?

Sorry for the size of the message, but I tried to be as clear as possible ....

Thank you to everyone who can help!


oracle version

Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
PL/SQL Release 9.2.0.8.0 - Production
CORE 9.2.0.8.0 Production
TNS for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production
NLSRTL Version 9.2.0.8.0 - Production
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 15 2011
Added on Aug 16 2011
19 comments
1,098 views