Re: How to find dependencies
From: Mahesh Rajendran <magvivek_at_gmail.com>
Date: Wed, 3 Sep 2008 13:57:47 -0400
Message-ID: <18df9070809031057q6850c18ak92d61a6aeb231835@mail.gmail.com>
Date: Wed, 3 Sep 2008 13:57:47 -0400
Message-ID: <18df9070809031057q6850c18ak92d61a6aeb231835@mail.gmail.com>
utldtree.sql?
On Wed, Sep 3, 2008 at 1:49 PM, Hameed, Amir <Amir.Hameed_at_xerox.com> wrote:
> 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
>
>
>
-- Mahesh Rajendran -- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 03 2008 - 12:57:47 CDT