Re: discover cause of object invalidation
- From: Timo Raitalaakso <rafu@xxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 03 Jun 2010 22:17:23 +0300
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
