Re: Invalid objects

From: Edorta <edortta_at_yahoo.es>
Date: Wed, 20 Oct 1999 16:55:05 +0200
Message-ID: <380DD7C9.5079E43C@yahoo.es>

You can't use an object which is in an invalid state. An object A becomes invalid when it depends on another object B, and B changes. For example, if you compile a package which contains a function used by a view, this view becomes invalid, etc.

Margaret Burwell wrote:

> If Iperform the query
>
> select owner||'.'||object_name, object_type from dba_objects
> where status = 'INVALID';
>
> I find a number of procedures, packages, package bodies and views are
> listed.
>
> What would cause an object to become invalid and what are the implcations
> for the application?
>
> Margaret
Received on Wed Oct 20 1999 - 09:55:05 CDT