Re: URGENT: Package keeps going invalid

  • From: Tim Gorman <tim@xxxxxxxxx>
  • To: john.kanagaraj@xxxxxxxxx
  • Date: Mon, 02 Jul 2007 18:23:38 -0600

Try auditing DDL statements? Check out the "audit_ddl.sql" script at http://www.EvDBT.com/tools.htm for enabling this....




John Kanagaraj wrote:
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)
--
http://www.freelists.org/webpage/oracle-l


Other related posts: