Last DDL Time for packages
Date: Tue, 28 Jul 2009 14:46:01 -0500
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')
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?
Roger XuReceived on Tue Jul 28 2009 - 14:46:01 CDT