Re: URGENT: Package keeps going invalid

  • From: "John Kanagaraj" <john.kanagaraj@xxxxxxxxx>
  • To: paulastankus@xxxxxxxxx
  • Date: Mon, 2 Jul 2007 16:16:29 -0700

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


Other related posts: