Re: invalidating packages

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 18 Dec 2000 18:03:13 +0100
Message-ID: <91ljm9$4k91n$1@ID-62141.news.dfncis.de>

No need, Packages will be automatically recompile as soon as you use them.

If you still want to recompile them manually, use dbms_utility.compile_schema.

Hth,

Sybrand Bakker, Oracle DBA

"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 Mon Dec 18 2000 - 11:03:13 CST