Package Body Compilation Problem
fac586Jul 27 2006 — edited Jan 9 2007I'm seeing a problem when compiling a package in SQL Developer.
- Expanding the package body node in the Connections navigator shows 2 error icons:
(X) Expecting end
(X) Expecting ;
- Compiling the package body in the editor window apparently succeeds with no error messages, but the navigator still shows the errors.
- Running a test suite on the package in SQL*Plus shows the following errors:
ORA-04061: existing state of has been invalidated
ORA-04061: existing state of package body "ASSERTION" has been invalidated
ORA-04065: not executed, altered or dropped package body "ASSERTION"
ORA-06508: PL/SQL: could not find program unit being called: "ASSERTION"
- Pasting the PL/SQL text from the editor window into SQL*Plus and compiling produces no errors and the package programs are executable.
- Refreshing the connection in SQL Developer after the successful SQL*Plus compilation still shows the errors under the package body node.
- Situation persists after restarting SQL Developer.
I remember this happening once before but I don't recall how I fixed it or if I determined the cause.
SQL Developer 1.0.0.15.57
Oracle Database 10g Express Edition Release 10.2.0.1.0
Windows XP SP 2