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: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Mon, 15 May 2006 20:19:29 +0800
Message-ID: <01b601c67819$d19e8420$6401a8c0@porgand>


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
Received on Mon May 15 2006 - 07:19:29 CDT

Original text of this message

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