Re: invalidating packages

From: Cliff Dabrowski <cliffdw_at_my-deja.com>
Date: Tue, 19 Dec 2000 18:34:26 -0500
Message-ID: <3a3ff061$1@172.22.1.229>

This is really not a problem as pointed out in the other posts. Oracle will take care of it for you.

One more point that has not been made... If my memory serves me correct then the dependant objects are only marked invalid if you have recompiled the package SPEC. If you keep your initial compilation limited to the BODY then the dependants will not be marked as invalid.

"Firstname Lastname" <username_at_cisco.com> wrote in message news:3A3E3E8F.C855527_at_cisco.com...
> Hello
>
> When I alter a table, all the packages that refers the tables get
> invalidated. Is this a new issue in 8i. We had altered the same table
> 1000 times (maybe more) in 7.3.4 and never ever did we have this
> problem.
>
> Pl. advise if there is a work around
>
> Thx
>
> SaraN
>
> skethara_at_cisco.com
>
>
Received on Tue Dec 19 2000 - 17:34:26 CST