Allow Locking feature to work with automatic re-compiles due to PL/SQL invalidation
It would be awesome if the tool would let automatic re-compiles work with Locked objects when a package spec/body is invalidated by a change to another package. As it is now - and automatic re-compile (without a code change) is blocked by the REDGATE.CHECK_LOCKS database trigger.
Could Red Gate be changed to allow automatic re-compiles (as opposed to code change compiles)? Perhaps performing a checksum between the code and the Subversion repository could work (though this would require the database instance to communicate with the repository).
Thanks!
1
vote
![](https://secure.gravatar.com/avatar/7d14c7b185d1efbd686438a087160887?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)