Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: invalidating packages

Re: invalidating packages

From: bgbgbg <brian.gallagher_at_iona.com>
Date: Mon, 18 Dec 2000 17:05:35 -0000
Message-ID: <91lgl0$81r$1@bvweb.iona.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US