Last DDL Time for packages

From: Roger Xu <>
Date: Tue, 28 Jul 2009 14:46:01 -0500
Message-ID: <>

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

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 Xu

Received on Tue Jul 28 2009 - 14:46:01 CDT

Original text of this message