0

I know how to find the last DDL for standalone procedures. Is there a way to do it for procedures written inside a package?

spiritedsea091
  • 13
  • 3
  • 2
    You can't update a single procedure in a package to begin with, you can only update the whole package. –  Feb 25 '20 at 12:21
  • 1
    Now you know why integrating a proper source control system (svn, git, whatever) can be so important. Who is changing what, when - and hopefully not treating your database as a source control system. – thatjeffsmith Feb 25 '20 at 12:25
  • Well, how do you find ( the last DDL for standalone procedures ) ? – Barbaros Özhan Feb 25 '20 at 13:05

1 Answers1

1

I think you can not. In any of USER_/ALL_/DBA_ OBJECTS, LAST_DDL_TIME column is related to the whole object - in your case, a package. Procedures that are part of the package aren't tracked.

So, you know when package was modified, but can't tell which part was it.

Littlefoot
  • 131,892
  • 15
  • 35
  • 57