Last DDL Time for packages
- From: Roger Xu <wellmetus@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 28 Jul 2009 14:46:01 -0500
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
Other related posts:
