RE: How to find dependencies
- From: "freek D'Hooge" <freek.dhooge@xxxxxxxxx>
- To: "'Clarke, Andrew'" <andrew.clarke@xxxxxxxxxx>, <Amir.Hameed@xxxxxxxxx>, "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 8 Sep 2008 10:01:26 +0200
Andrew,
Yes, the OverloadCheck package was probably what I remembered reading about.
Thanks for the tip on PL/Scope. Did not know that one.
Regards,
Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge@xxxxxxxxx
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer
-----Original Message-----
From: Clarke, Andrew [mailto:andrew.clarke@xxxxxxxxxx]
Sent: donderdag 4 september 2008 18:57
To: D'Hooge Freek; Amir.Hameed@xxxxxxxxx; ORACLE-L
Subject: RE: How to find dependencies
>> 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/feuerst
ein_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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
