Re: URGENT: Package keeps going invalid

From: John Kanagaraj <john.kanagaraj_at_gmail.com>
Date: Mon, 2 Jul 2007 16:16:29 -0700
Message-ID: <2ead3a60707021616v77057599s248c62ad0fbb9601@mail.gmail.com>

Paula,

> 2-What is the most efficient way to track WHAT made a package go invalid?

You might want to place a DDL trigger in the database to keep track of what changes are ongoing.... this might give you additional clues..... Let me know if you want the code for this (I remember I posted this to the list a while ago)

-- 
John Kanagaraj <><
DB Soft Inc
Phone: 408-970-7002 (W)

** The opinions and facts contained in this message are entirely mine
and do not reflect those of my employer or customers **
--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jul 02 2007 - 18:16:29 CDT