How to find dependencies
From: Hameed, Amir <Amir.Hameed_at_xerox.com>
Date: Wed, 3 Sep 2008 13:49:40 -0400
Message-ID: <304F58144267C5439E733532ABC9A3A106CAC23D@USA0300MS02.na.xerox.net>
Date: Wed, 3 Sep 2008 13:49:40 -0400
Message-ID: <304F58144267C5439E733532ABC9A3A106CAC23D@USA0300MS02.na.xerox.net>
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-lReceived on Wed Sep 03 2008 - 12:49:40 CDT