Re: Why do objects become invalid?

From: Guido Konsolke <Konsolke_at_KHIS.KRUPP.COM>
Date: Wed, 16 Sep 1998 08:04:23 +0200
Message-ID: <35FF54E6.C3C709E@KHIS.KRUPP.COM>

Hi Violin,

this happens when database objects like tables (which are 'used' by the procedure) are changed. E.g.: a new column was applied to one table.

hth
Guido

Violin schrieb:

> Hello,
> I want to ask a question,
> When I connect as system/mamanger and
> SELECT * FROM ALL_OBJECTS WHERE STATUS = 'INVALID';
> I can find some objetcs like procedures,triggers,views become INVALID.
> And if I recompile the scripts,the objects' STATUS become VALID.
> But I don't know why?
> 'Cause I don't alter the objects,but they become INVALID.
> Please give me more information about this.
> Please Cc to : violin.hsiao_at_mail.pouchen.com.tw,Thank you :-)
Received on Wed Sep 16 1998 - 01:04:23 CDT