Re: Packages vs. Procedure

From: Peter Schneider <peter.schneider_at_okay.net>
Date: Sun, 27 Sep 1998 12:17:27 GMT
Message-ID: <6ul6sl$3i3$1@news.ipf.net>

anonymous <anonymous_at_anonymous.com> wrote:

[...]

>pkg_x
> view_y
> pkg_z
> pkg_zz.
>
>view_y depends on pkg_x, pkg_z depends on view_y etc. When I recompile =
view_y
>pkg_z gets invalid. After 'alter package pkg_z recompile;' pgk_zz is =
invalid.
>As far as I know it is not possible to just recompile the package body.

Hi Ronald,

you might want to try:

ALTER PACKAGE my_package COMPILE BODY;

so that objects that depend on the package specification won't become invalid again.

HTH,
Peter

--
Peter Schneider
peter.schneider_at_okay.net Received on Sun Sep 27 1998 - 07:17:27 CDT