Cannot change Function definition (Session hangs)
Oracle 10g (10.1)
Windows 2003 server.
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.
Please advice. Thanks
Last edited by daljitsb; 03-21-2007 at 12:32 PM.
have you ran the script I provided you in "Oracle Database Administration" forum?
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
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.
Click Here to Expand Forum to Full Width