RE: Dependency tree of packages/procedures and functions

First question is why? Let the DB track the dependencies; it's good at it. Letting humans do it is error prone and painful.

Tracking dependencies from front/middle layers to Oracle -- dependencies Oracle is not aware of -- that is a good idea.

That said, I did encounter a similar situation to yours in my early years with pl/sql where I coded all my constants in a single package named "C". Big mistake. In the end everything depended on this package and any new additions would cause a 10-15 downtime when moving in enhancements/fixes due to all the recompilation. This was a 24X7 application, so what a mistake.

The fix was to break the package up, keeping related constants in module-specific package specs.

If you still insist on a tree, you may derive from benefit by tweaking this code to operate in a loop on every object in your database. It's a little dated, so no guarantees...

http://www.oracle.com/technology/oramag/code/tips2002/090802.html

• bill c.

-----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 2: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
=20________________________________________________
George Leonard
Oracle Database Administrator
New Dawn Technologies @ Wesbank
E-mail:gleonard_at_wesbank.co.za
=20

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!
=20

_________________________________________________________________________=
__________________________

The views expressed in this email are, unless otherwise stated, those of = the author and not those
of the FirstRand Banking Group an Authorised Financial Service Provider o= r its management.
The information in this e-mail is confidential and is intended solely for=
=20the addressee.

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

=20 ________________________________

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

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