Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Timeout Error in Package compilation!!!

596585Feb 19 2009 — edited Feb 20 2009
Hi,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 20 2009
Added on Feb 19 2009
5 comments
2,227 views