Re: Finding the cause of object invalidation

If you try and compile them (alter procedure/package/trigger compile) - check user_errors or dba_errors view for the cause of the failed compile.

Stefan

On 8/26/06, Nirmalya Das <nirmalya_at_hln.com> wrote:
>
> How do I figure out the cause of objects (Procedure, Package, Trigger)
> became
> INVALID?
>
> Any pointers will be greatly appreciated....
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l