RE: How to find dependencies
- From: "freek D'Hooge" <freek.dhooge@xxxxxxxxx>
- To: <Amir.Hameed@xxxxxxxxx>, "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 4 Sep 2008 12:34:46 +0200
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@xxxxxxxxx
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
