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

From: keith boulton <boulke_at_globalnet.co.uk>
Date: Sat, 09 Jan 1999 14:38:19 GMT
Message-ID: <369768f9.1489421@read.news.globalnet.co.uk>

On Thu, 07 Jan 1999 14:28:33 GMT, Veli-Matti Suominen <vsu_at_modultek.fi> 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!
>

I've not experimented, but I would expect the wrapped version of a given procedure to always be the same, therefore inspect the user_source table and compare the form stored there with the expected form for each of your procedure versions. Received on Sat Jan 09 1999 - 08:38:19 CST