I need to modify a Stored Function but when ever I try to make change and compile (in PLSQL developer etc.), db stops responding and I have to kill the session.
The Function (GetDecodeValue) is referenced by about 30 views and 1 Function.
I can execute the Function anytime and but cannot make any changes even when there is no user accessing the Function. There is no lock, I checked.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.