Re: How to find dependencies

From: Yaping Chen <hangzhoumaster_at_gmail.com>
Date: Thu, 11 Sep 2008 11:43:29 +0800
Message-ID: <170d3ad90809102043j7b9119e4kc97000fed1f44106@mail.gmail.com>

Hi Amir,

You may try this procedure dbms_utility.GET_DEPENDENCY.

---

sys_at_TEST>exec <sys_at_TEST%3Eexec>dbms_utility.GET_DEPENDENCY('TABLE','TEST','T1'); -
DEPENDENCIES ON TEST.T1

---

*TABLE TEST.T1()
*   FUNCTION TEST.FUN_T1_01()
*      FUNCTION TEST.FUN_T1_02()

PL/SQL procedure successfully completed.

2008/9/4 Hameed, Amir <Amir.Hameed_at_xerox.com>

> 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
>
>
>

-- 
Regards,
Yaping Chen

http://yaping123.wordpress.com

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

Received on Wed Sep 10 2008 - 22:43:29 CDT