Re: invalid packages

the functions are transparently revalidated when invoked from most oracle products (eg sqlplus, forms). i have found Discoverer 2000 does not do this however.
so normally it is not a problem?
otherwise check out alter procedure/function/package statements which will recompile for you.

Stefan Keller wrote:
> if I make changes in the structure of a table, and PL/SQL-Function
> reads this table, the function gets the status =91invalid=92.
> Does a package contain this function, the whole package is =91invalid=92=
 =2E
> In this case other functions in the same package are invalid.
> What can I do or do I have to recompile the packages always when I
> make changes on one of those tables?
> =
 

> answer to Stefan.Keller_at_oiz.stzh.ch

• =

Steve Corbett. Perth Australia . =

stevec_at_fcs.wa.gov.au
scorbett_at_perth.dialix.oz.au Received on Wed Jul 23 1997 - 00:00:00 CDT