Hi,
I am trying out a hierarchical query in the following example: in v$dependecies you find can find all objects that are dependant from any other object. I have to know the hierarchy of dependancies in order to recompile my packages in the right way, after having compiled one package.
So I begin with one specific package from the field "referenced_name" and find all dependant objects in the field "name". Then I have to take every one of those objects, look for them in the field "referenced_name" and find out the objects that are dependant from them.
I tried to solve this with a hierarchical query, like that:
select referenced_name, level
from user_dependencies
start with referenced_name=<Package-name whose dependencies I want to explore>
connect by prior referenced_name = name
Oracle answers to this with "ora-01436: connect by loop in user data"
Why? What I intend to do certainly does not contain an infinite loop. Can I use the hierarchical query here?
Thanks in advance,
Xenofon