Re: How to find dependencies
- From: "Yaping Chen" <hangzhoumaster@xxxxxxxxx>
- To: Amir.Hameed@xxxxxxxxx
- Date: Thu, 11 Sep 2008 11:43:29 +0800
Hi Amir,
You may try this procedure dbms_utility.GET_DEPENDENCY.
-----------------------------
sys@TEST>exec <sys@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@xxxxxxxxx>
> 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
>
>
>
--
Regards,
Yaping Chen
http://yaping123.wordpress.com
Other related posts:
