Re: IMPORTANT DEPENDENCIES QUESTION IN ORACLE.

its more complex than that since package specs can have seperate
dependencies from package bodies. DBA_DEPENDECIES will only list objects
that have dependecies. So your spec might have a dependencies and your body
does not. So you will need to add code to account for this so your
dependency tree doesnt have gaps.

I had to write packages,procedures, and function code to a file in
dependecies order so they could be re-imported elsewhere. Its not that
simple. I found the utldeptree to be totally worthless. I did it solely with
DBA_DEPENDENCIES and DBA_OBJECTS(needed this view in case object didnt have
dependencies so I diff'd it to the DBA_DEPENDENCIES).

It was a real nuissance. I dont have code to tell you a tree, it just writes
the code out. A tree would be more complicated.

"Lakshmi Jagarlapudi" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi Everybody,
>
> I have been working in Oracle database for a while. I am actually looking
> for an easy way to get a dependency tree. I know Oracle
> provides us with the script "utldtree.sql",however I am not really
succesful
> in using it.
>
> To be more clear,  what I want is ,say if there is a package A, which
access
> package B, which access view V which in turn is based
> on table T. Then I want in a tree like structure the above dependencies
give
> the package A as a parameter.
>
> Please let me know if you have any soltution.
>
> thanks in advance.
>
>