From oracle-l-bounce@freelists.org Tue Jan 11 09:44:21 2005 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id j0BFgv620033 for ; Tue, 11 Jan 2005 09:42:57 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id j0BFgrn20015 for ; Tue, 11 Jan 2005 09:42:54 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2137372CBC6; Tue, 11 Jan 2005 10:49:28 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 13300-42; Tue, 11 Jan 2005 10:49:27 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EDB8572C130; Tue, 11 Jan 2005 10:46:22 -0500 (EST) Subject: Re: Dependency tree of packages/procedures and functions From: "Mark J. Bobak" To: GLeonard@wesbank.co.za Cc: Oracle-L Freelists In-Reply-To: <1831A554E8800049B6B970790D2513C001C35F92@fnbkrkmx01.fnb.co.za> References: <1831A554E8800049B6B970790D2513C001C35F92@fnbkrkmx01.fnb.co.za> Content-type: text/plain Organization: MJB Consulting Message-Id: <1105458089.4556.303.camel@bobak.net> Mime-Version: 1.0 Date: Tue, 11 Jan 2005 10:41:29 -0500 Content-Transfer-Encoding: 8bit X-archive-position: 14606 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: mark@bobak.net Precedence: normal Reply-To: mark@bobak.net X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org To borrow a phrase from Tom Kyte, "Repeat after me: Packages break the dependency chain!" In other words, if you package all your functions and procedures, the dependency chain is easy. The steps are: 1.) Compile all package specs. 2.) Compile all package bodies. That's it, you're done. No recursive relationships, no cases of a single function or package invalidating dozens of other objects..... Hope that helps, -Mark On Tue, 2005-01-11 at 03:34, Leonard, George wrote: > 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@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 -- Mark J. Bobak mark@bobak.net "Science is the belief in the ignorance of experts." --Richard P. Feynman -- http://www.freelists.org/webpage/oracle-l