Re: Recompiling tool

From: Rune Nygård <rune.nygaard_at_naviaav.no>
Date: Mon, 25 May 1998 12:13:43 +0200
Message-ID: <35694457.2600FBBC@naviaav.no>

Check http://www.oramag.com/code/tip06247.html It will create "alter packate/procedure/view <name> compile;" statements in the correct dependency order for you.

/Rune

Jan Kjetil wrote:

> I have a database with many dependencies among the packages with PL/SQL
> code.
> When a package is recompiled the dependent code packages are set
> to invalid even if the compiled package is valid.
>
> Does anybody know about any recompiling tool for Oracle which can
> be helpful in this situation?
>
> jka_at_nextel.no
Received on Mon May 25 1998 - 05:13:43 CDT