Re: discover cause of object invalidation

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