RE: Dependency tree of packages/procedures and functions

  • From: "Joze Senegacnik" <Joze.Senegacnik@xxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 11 Jan 2005 10:40:19 +0100

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@xxxxxxxxxxxxx =
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]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@xxxxxxxxxxxxx
=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

_________________________________________________________________________=
=3D
__________________________


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                              ________________________________
--
//www.freelists.org/webpage/oracle-l

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

Other related posts: