|
-
 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
-D
Last edited by daljitsb; 03-21-2007 at 11:32 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote