Connecting Tech Pros Worldwide Forums | Help | Site Map

ORA-04021: timeout occurred while waiting to lock object PARTNER1.PKG_UTILITY

Newbie
 
Join Date: Aug 2007
Posts: 7
#1: Sep 19 '07
Hi anybody,
I was getting error like below while compiling package

SQL> @pkg_utility.sql
CREATE OR REPLACE PACKAGE pkg_utility
*
ERROR at line 1:
ORA-04021: timeout occurred while waiting to lock object PARTNER1.PKG_UTILITY


please assist me.

numberwhun's Avatar
Site Moderator
 
Join Date: May 2007
Location: New Hampshire
Posts: 2,572
#2: Sep 19 '07

re: ORA-04021: timeout occurred while waiting to lock object PARTNER1.PKG_UTILITY


Quote:

Originally Posted by gautamga

Hi anybody,
I was getting error like below while compiling package

SQL> @pkg_utility.sql
CREATE OR REPLACE PACKAGE pkg_utility
*
ERROR at line 1:
ORA-04021: timeout occurred while waiting to lock object PARTNER1.PKG_UTILITY


please assist me.

Considering the SQL prompt, I am going to guess that this is a database question and not a Perl question. Please let me know if you have a Perl question or I will have to move this thread to the appropriate forum. If it is specifically a database question, please let me know which database you are using and I will make sure it ends up in its forum.

Regards,

Jeff
numberwhun's Avatar
Site Moderator
 
Join Date: May 2007
Location: New Hampshire
Posts: 2,572
#3: Sep 19 '07

re: ORA-04021: timeout occurred while waiting to lock object PARTNER1.PKG_UTILITY


Quote:

Originally Posted by gautamga

Hi anybody,
I was getting error like below while compiling package

SQL> @pkg_utility.sql
CREATE OR REPLACE PACKAGE pkg_utility
*
ERROR at line 1:
ORA-04021: timeout occurred while waiting to lock object PARTNER1.PKG_UTILITY


please assist me.

Considering the ORA in your error, I will assume that this is an Oracle database. Since there is no relevant Perl question I am migrating this post to that Forum.

If this is not an Oracle database issue, then I ask that a Moderator here please move it to the appropriate DB forum.

Regards,

Jeff
Saii's Avatar
Expert
 
Join Date: Apr 2007
Posts: 141
#4: Sep 20 '07

re: ORA-04021: timeout occurred while waiting to lock object PARTNER1.PKG_UTILITY


Quote:

Originally Posted by numberwhun

Considering the ORA in your error, I will assume that this is an Oracle database. Since there is no relevant Perl question I am migrating this post to that Forum.

If this is not an Oracle database issue, then I ask that a Moderator here please move it to the appropriate DB forum.

Regards,

Jeff

It seems some other process is using the package or there is exclusive lock on some table referred in package.
Reply