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??
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.
-- //www.freelists.org/webpage/oracle-l
-- Best regards, Alex Gorbachev
http://oracloid.blogspot.com -- //www.freelists.org/webpage/oracle-l