RE: How to find dependencies
- From: "Clarke, Andrew" <andrew.clarke@xxxxxxxxxx>
- To: <freek.dhooge@xxxxxxxxx>, <Amir.Hameed@xxxxxxxxx>, "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 4 Sep 2008 17:56:45 +0100
>> If memory services me right, Steven Feuerstein has created a package that
>> would build such a depency tree for pl/sql packages
Were you think of Steven's OverloadCheck package? That checks packages for
ambiguous overloading so it doesn't really deal with procedure-level
dependencies. But I imagine it gives a good insight into how one might roll
one's own. The following link takes you to Part 1 of 8
http://www.oracle.com/technology/oramag/webcolumns/2003/techarticles/feuerstein_codech.html
Alternatively, in 11g there is fine-grained dependency checking with PL/Scope.
Tom wrote about it here:
http://www.oracle.com/technology/oramag/oracle/07-nov/o67asktom.html
Cheers, APC
A P Clarke
Software Architect
Logica UK Public Sector Division
Stephenson House
75 Hampstead Road
London
UK
NW1 2PL
Direct Tel: +44 (0)207 230 3160
Fax: +44 (0)207 446 1352
Email: andrew.clarke@xxxxxxxxxx
This e-mail and any attachment is for authorised use by the intended
recipient(s) only. It may contain proprietary material, confidential
information and/or be subject to legal privilege. It should not be copied,
disclosed to, retained or used by, any other party. If you are not an intended
recipient then please promptly delete this e-mail and any attachment and all
copies and inform the sender. Thank you.
Other related posts:
