Re: discover cause of object invalidation

From: Timo Raitalaakso <>
Date: Thu, 03 Jun 2010 22:17:23 +0300
Message-ID: <>

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

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

See the first comment in


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.
Received on Thu Jun 03 2010 - 14:17:23 CDT

Original text of this message