ORA-04061: existing state of has been invalidated
kendennyMay 21 2009 — edited Dec 17 2010I'm using PL/SQL Developer. I am running a package that was developed by a colleague of mine used for test. It runs the same query or procedure on two databases and compares the results. Anyway the problem I having is when I run it via a regular SQL window it always fails on one particular package saying that the package body has been invalidated. BUT I can run it in the test window and it executes correctly. Any ideas?
Edit. The first error message is exactly the thread title, without the name of the package that has been invalidated. The second line of the error message has the name. the message is as follows:
ORA-04061: existing state of has been invalidated
ORA-04061: existing state of package body "FO_RESULTS.PK_PLANALYSER_T1" has been invalidated
ORA-04065: not executed, altered or dropped p
The log chops it off after that. I'll put in some dbms_output and get the full error message,
Edit2. I just tried running it in SQL*Plus and it executes correctly there. I may have encountered a bug in PL/SQL developer.
Edited by: kendenny on May 21, 2009 11:15 AM
Edited by: kendenny on May 21, 2009 11:20 AM