daljitsb
03-21-2007, 11:07 AM
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
-D
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
-D