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,
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-lReceived on Tue Jul 28 2009 - 14:46:01 CDT