Timeout Error in Package compilation!!!
596585Feb 19 2009 — edited Feb 20 2009Hi,
I have a package created in client environment DB. I was using that package and it was working. When I did code change and try to compile it was timing out. I thought some dependencies are there. But When I queried V$session I found no dependencies.
Whenever I compile that package it is saying Timeout Occured. I tried for dropping the package. For drop package also same error.
Is this error because object is locked? How to unlock the object.
SQL Error: ORA-04021: timeout occurred while waiting to lock object APPS.
I dont want to change the package name.
I compiled other packages , procedures, they are compiling successfully.
Please any one help me in this.
Thanks
Alaka