RE: How to find dependencies
Date: Thu, 4 Sep 2008 12:34:46 +0200
If memory services me right, Steven Feuerstein has created a package that would build such a depency tree for pl/sql packages (showing which views, tables, other packages where used by the code). The coding for this package appeared as a serie in oracle magazine.
I did a quick search on google, but did not find it back. Maybe if you drop him an email?
Ps, if you did find it back, could you then the location to me or to the list?
Oracle Database Administrator
tel +32(0)3 451 23 82
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Hameed, Amir
Sent: woensdag 3 september 2008 19:50
Subject: How to find dependencies
Here is the scenario; If a PL/SQL package contains multiple procedures and functions and there are triggers referencing a certain procedure in that package then is there a way to list all those triggers? The DBA_DEPENDENCIES view does not drill down to the sub-programs within a package.
http://www.freelists.org/webpage/oracle-l Received on Thu Sep 04 2008 - 05:34:46 CDT