RE: Dependency tree of packages/procedures and functions

George,

Fortunately Oracle maintains a dependency list. Thus if you e.g. change a table
definition, Oracle knows which objects
to invalidate.

You can see the list it in DBA_DEPENDENCIES.

DESCRIBE dba_dependencies

 Name                                      Null?    Type
 ----------------------------------------- --------
----------------------------
 OWNER                                     NOT NULL VARCHAR2(30)
 NAME                                      NOT NULL VARCHAR2(30)
 TYPE                                               VARCHAR2(17)
 REFERENCED_OWNER                                   VARCHAR2(30)
 REFERENCED_NAME                                    VARCHAR2(64)
 REFERENCED_TYPE                                    VARCHAR2(17)
 REFERENCED_LINK_NAME                               VARCHAR2(128)
 DEPENDENCY_TYPE                                    VARCHAR2(4)

Hope this helps.

Regards
Jesper Haure Norrevang

-----Oprindelig meddelelse-----
Fra: oracle-l-bounce_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org] P=E5 vegne af Leonard, George
Sendt: 11. januar 2005 09:35
Til: Oracle-L Freelists
Emne: 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