RE: Dependency tree of packages/procedures and functions

You can use ?\rdbms\admin\utlrp.sql script to recompile invalid objects. = This script is using utl_recomp package defined in the = ?\rdbms\admin\utlrcmp.sql. If required, you can change the functionality = of the script to fit your requirements.

Regards, Joze

-----Original Message-----
From: oracle-l-bounce_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Leonard, George Sent: Tuesday, January 11, 2005 9:35 AM
To: Oracle-L Freelists
Subject: Dependency tree of packages/procedures and functions

Hi all

Hope you can help.

As with all big projects our developers forgot to listen to us when we asked them to keep a dependency tree what calls what.

Now we are busy going into pre-prod etc and get asked to move Package A, doing this nicely goes and breaks half the world down the line,

I would like to run something against the database (packages, procedures and functions) to generate a dependency list.

Any ideas what is out there that can do this (freeware prepared), any output acceptable.

George
=3D20________________________________________________
George Leonard
Oracle Database Administrator
New Dawn Technologies @ Wesbank
E-mail:gleonard_at_wesbank.co.za
=3D20

You Have The Obligation to Inform One Honestly of the risk, And As a Person
You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit!
=3D20

_________________________________________________________________________=

The views expressed in this email are, unless otherwise stated, those of =
=3D

the author and not those
of the FirstRand Banking Group an Authorised Financial Service Provider = o=3D
r its management.
The information in this e-mail is confidential and is intended solely = for=3D
=3D20the addressee.

Access to this e-mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, = distribut=3D
ion or any action taken or=3D20
omitted in reliance on this, is prohibited and may be unlawful. Whilst all reasonable steps are taken to ensure the accuracy and = integrit=3D
y of information and data=3D20
transmitted electronically and to preserve the confidentiality thereof, = n=3D
o liability or=3D20
responsibility whatsoever is accepted if information or data is, for = what=3D
ever reason, corrupted=3D20
or does not reach its intended destination.

=3D20 ________________________________

--
http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l