Skip to Main Content

SQL Developer

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!

Package Body Compilation Problem

fac586Jul 27 2006 — edited Jan 9 2007
I'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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 6 2007
Added on Jul 27 2006
8 comments
6,543 views