Re: Package Dependancy Order

Hi Colin,

if you first compile all your packages there will be no problem in compiling any package body.

Here is a tool which shows the dependencies: Hora 3, see http:\\www.keeptool.com for a 30 days free trial version.

regard Jan Dieckmann

Colin Woods wrote:

> Folks
>
> I have a database where I compile a large amount of packages.
> Unfortunately I haven't got the dependency right, with the result that I
> have a number of INVALID packages body's at the end.
>
> Currently I use the ALTER PACKAGE command or the
> DBMS_UTILITY.COMPILE_SCHEMA utility to resolve this problem.
>
> However I want to tidy my compile process. Is there command or utility
> that I can use which will list a users package dependency order.
>
> regards
> Colin Woods
> cwoods_at_talk21.com
Received on Thu Nov 12 1998 - 10:42:03 CST