Last DDL Time for packages

From: Roger Xu <wellmetus_at_gmail.com>
Date: Tue, 28 Jul 2009 14:46:01 -0500
Message-ID: <eb64345d0907281246l7fcde784x2b79b95a2de39bc8_at_mail.gmail.com>



Hi List,

We are trying to use below SQL to obtain the last time at which a package/procedure/function being modified. It seems to be working for procedure and functions, but not for the package.

select to_char(LAST_DDL_TIME, 'YYYY MM DD HH:MI:SS') from dba_OBJECTs
where OBJECT_NAME = 'MYPACKAGE';

Is there any other way to find out a package's source code was changed? Maybe I should look into the link between package and procedures?

Thanks,

Roger Xu

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jul 28 2009 - 14:46:01 CDT

Original text of this message