Oracle Package hangs while compiling (2) [message #425242] |
Thu, 08 October 2009 04:08  |
Ankita06666
Messages: 2 Registered: October 2009 Location: New Delhi
|
Junior Member |
|
|
Hi,
I have a package,I was able to compile the package recently..but from yesterday while compiling the session hangs.I have checked the package is not locked.
What could be the probable problem?
|
|
|
|
|
Re: Oracle Package hangs while compiling (2) [message #425275 is a reply to message #425251] |
Thu, 08 October 2009 06:51   |
JRowbottom
Messages: 5933 Registered: June 2006 Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
That shouldn't be a problem for a package - compile the package and then the package body and you'll be fine - if you've got the dependencies in the body the wrong way round you'll get an error, not a hang.
Thinking about it, I reckon it's more likely that someone has got an object that depends on this package locked - to recompile the package you need to invalidate all the dependant objects, and if they're locked then you'll just have to wait.
Have you looked in v$session_wait to see what the hung session is waiting on?
|
|
|
|
|
Re: Oracle Package hangs while compiling (2) [message #425330 is a reply to message #425242] |
Thu, 08 October 2009 11:30  |
 |
Kevin Meade
Messages: 2103 Registered: December 1999 Location: Connecticut USA
|
Senior Member |
|
|
the only time I have seen packages hang on compile is when the package is in use (as was stated above).
My best guess is you have another session using the package and that session has in waiting on something. Most likely it is one of your own old sessions.
Try getting rid of sessions by closing open tools. If all else fails, you can reboot your oracle instance to make sure there are no sessions that could have your package in use, then recompile.
Good luck, Kevin
|
|
|