RE: How to find dependencies

Amir,

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?  

Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge_at_uptime.be
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer

-----Original Message-----

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
To: ORACLE-L
Subject: How to find dependencies

Hi Folks,
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.

Thanks
Amir

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Thu Sep 04 2008 - 05:34:46 CDT