Re: discover cause of object invalidation

From: Timo Raitalaakso <rafu_at_iki.fi>
Date: Thu, 03 Jun 2010 22:17:23 +0300
Message-ID: <4C07FFC3.2010305_at_iki.fi>


Without seeing your procedure it is quesswork. One way to invalidate a procedure is to do inside something like

EXECUTE IMMEDIATE 'DROP TABLE test';
EXECUTE IMMEDIATE 'CREATE TABLE test (col1 varchar2(1))';

See the first comment in

http://rafudb.blogspot.com/2009/11/invalid-procedure.html

--
Rafu

On 3.6.2010 21:46, Stephens, Chris wrote:

>
> We have a package that is invalidated on a somewhat regular basis. Iím
> trying to figure out the cause of the invalidation. I can see what
> objects it depends on but I canít find a way to actually determine
> what caused the invalidation.
>
>
-- http://www.freelists.org/webpage/oracle-l
Received on Thu Jun 03 2010 - 14:17:23 CDT

Original text of this message