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)
-- //www.freelists.org/webpage/oracle-l