Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: CATPROC gets invalidated
Maybe this. I didn't really pay attention to this feature...
Anyway, opening Sev1 SR with Oracle. It seems reproduced again and
strange thing:
I open new session as sys and try DBMS_STAT - get this error. Than I
run DBMS_REGISTRY_SYS.VALIDATE_CATPROC. Again DBM_STATS and viola! it
works.
New session - error again. Something to do with session state... where??
2006/5/15, Tanel Põder <tanel.poder.003_at_mail.ee>:
> Do you mean that altering an object which is referenced by PL/SQL
> package/procedure through a synonym won't invalidate that PL/SQL object on
> certain conditions.
>
>
> Tanel.
>
> >
> > Good idea. Thanks.
> > However, DBMS_STANDARD was not maked as invalid last time and was not
> > modified since I reloaded catproc last time. Will try to see it
> > anyway.
> > I recall there is a new feature with invalidation of PL/SQL objects in
> > 10g.... I can't recall what is that about.
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- Best regards, Alex Gorbachev http://oracloid.blogspot.com -- http://www.freelists.org/webpage/oracle-lReceived on Mon May 15 2006 - 07:32:06 CDT
![]() |
![]() |