liste recursive dependences

Ca y est je l'ai trouvé, y'a juste a mettre le nom du pacjage et son type et HOP

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
select lvl, u.object_id, u.object_type, LPAD(' ',lvl)||object_name obj
FROM
(
SELECT level lvl, object_id
FROM SYS.public_dependency s
START WITH s.object_id = (select object_id 
from user_objects 
where object_name=UPPER('&OBJECT_NAME')
and object_type =UPPER( '&OBJECT_TYPE' )
)
CONNECT BY s.object_id = PRIOR referenced_object_id
GROUP BY level, object_id
)tree,
user_objects u
WHERE
tree.object_id = u.object_id
ORDER BY lvl 
/