How to find dependencies

  • From: "Hameed, Amir" <Amir.Hameed@xxxxxxxxx>
  • To: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 3 Sep 2008 13:49:40 -0400

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


Other related posts: