Re: How to keep track of the changes to PL/SQL procedures

I don't know whether this helps, however in dba_objects (and of course also in all_objects and user_objects) both the creation date and the last_ddl_time are being maintained.

Regards,

Sybrand Bakker, Oracle DBA

Veli-Matti Suominen wrote:

> I need to know which version of wrapped procedure our customer is using.
> There could be installed customized version or standard version.
> Depending of the version there has to be done different upgrade
> procedures. Each customer may have different customized version. And
> each database has over 700 procedure or package. I'm using Oracle
> 7.3.4.3 version.
> Because of the amount of the installations and the fact that I can't be
> sure how has done some changes, I need a secure method to know which
> version of the package or procedure is installed before I can make any
> upgrades to newer versions of procedures.
>
> I've tried to trigger source$ table, but as it is owned by SYS it is not
> possible. Is there any other way to trigger changes to procedures?
> Or does anybody have any ideas to solve my problem?
> Thanks!

Received on Thu Jan 07 1999 - 09:20:30 CST