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

[gautamga]

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

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


please assist me.

[numberwhun]

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

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


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]

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

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


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]

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.