Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: invalidating packages
It has always been the same - but a) oracle attempts to re-compile when package is next called. b) you can attempt to re-compile package
alter pakage ABC compile [body];
rgds
brian
"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:05:35 CST