modification date for package SP [message #669328] |
Mon, 16 April 2018 02:44 |
|
OraFerro
Messages: 433 Registered: July 2011
|
Senior Member |
|
|
Hi all,
How do I know the last modification date for a stored procedure under a certain package?
Using the following can only get information about stored procedures that are NOT under package, and modifying
returns information about the whole package.
SELECT LAST_DDL_TIME, TIMESTAMP
FROM DBA_OBJECTS
WHERE OBJECT_TYPE = 'PROCEDURE'
and
AND OBJECT_NAME = 'My_SP';
Thanks,
Ferro
|
|
|
Re: modification date for package SP [message #669330 is a reply to message #669328] |
Mon, 16 April 2018 03:11 |
cookiemonster
Messages: 13943 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
The question is meaningless - you don't compile/run in individual procedures in a package.
You compile/ run in the package body and / or package spec as a whole.
So you'll only find a time against the package body and spec in the data dictionary.
Oracle doesn't know nor care that when you last changed the package you only altered a single procedure in it.
If you want to know when a particular procedure in a package was changed you'll need to compare versions in your source control repository.
|
|
|
|
Re: modification date for package SP [message #669337 is a reply to message #669336] |
Mon, 16 April 2018 06:54 |
Solomon Yakobson
Messages: 3285 Registered: January 2010 Location: Connecticut, USA
|
Senior Member |
|
|
Meditate over PACKAGE vs PACKAGE BODY and therefore:
SELECT LAST_DDL_TIME, TIMESTAMP
FROM DBA_OBJECTS
WHERE OBJECT_TYPE = 'PACKAGE'
AND OBJECT_NAME = 'My_package';
Versus:
SELECT LAST_DDL_TIME, TIMESTAMP
FROM DBA_OBJECTS
WHERE OBJECT_TYPE = 'PACKAGE BODY'
AND OBJECT_NAME = 'My_package';
SY.
|
|
|
|