Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: CATPROC gets invalidated

Re: CATPROC gets invalidated

From: Andrey Kriushin <Andrey.Kriushin_at_rdtex.ru>
Date: Mon, 15 May 2006 20:59:30 +0400
Message-ID: <4468B372.7070505@rdtex.ru>


Alex,

you can check Note:136697.1 for hcheck8i.sql package. I've found it quite useful in finding inconsistencies in the data dictionary. Last release is adopted to 8i-10g versions of DB.

HTH

Alex Gorbachev wrote:
> 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
>>

--
http://www.freelists.org/webpage/oracle-l
Received on Mon May 15 2006 - 11:59:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US