PL/SQL Compilation - Timeout Error
JDBDec 6 2005 — edited Dec 12 2005I have a PL/SQL package that consists of a single function. The function is declared in the spec, and defined in the package body. I can compile the package body and all is well. However, when I go to compile the package spec I wait for something like 5 minutes, then get back this error:
Error: ORA-04021: timeout occurred while waiting to lock object MO_DOI.TBX
[12:54:28 PM] Compilation complete: 1 errors, 0 warnings.
The JDeveloper version is 10.1.3.0.3 Studio, the DB is Oracle 9i. TOAD shows the package and spec are in a valid state. The code can execute, even from a PL/SQL Worksheet in the very same JDeveloper session that had the error. (That test was done with SQL statement
select (mo_doi.tbx.cnvNum2Verbose(0)) as test from dual;)
I get the same results on two different Oracle instances on two different boxes. JDeveloper is running on WinXP Sp2, the database is on a Windows Server.
I'm not able to find a bug report directly on point. Is this part of a known issue, or is there something else I need to try on my end?
James Brockman