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 - 08:28:33 CST
