Hi,
Could some one please help me in finding out the object dependencies among objects?
I was trying to find out the all levels of dependencies for a given object in a given schema, but this following query is not working for packages type.
I want to find out all LEVELS of object involved in the creation of a package.
Example:
SELECT DISTINCT owner,name,referenced_owner,referenced_name,referenced_type, LEVEL Le1
FROM dba_dependencies
where owner =user
START WITH NAME = 'object name'
CONNECT BY NOCYCLE PRIOR referenced_name = NAME
--AND PRIOR REFERENCED_OWNER = OWNER
--AND REFERENCED_TYPE = 'PACKAGE'
ORDER SIBLINGS BY name
Please help.