Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to keep track of the changes to PL/SQL procedures
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
![]() |
![]() |