Thursday, January 6, 2011

ORA-04068: existing state of packages has been discarded

Everythings right but you still see:

ORA-04068: existing state of packages has been discarded
ORA-04061: existing state of package "PKG.PROC" has been invalidated
ORA-04065: not executed, altered or dropped package "PKG.PROC"
ORA-06508: PL/SQL: could not find program unit being called


My dataset points to a stored procedure. The stored proc
executed just fine when kicked off from the database.
It even worked fine when I tested it from Query Designer
within SSRS.

What worked for me is to just close and reopen my
MS Visual Studio IDE.
This post says to log out and log back in.
But I work in a version controlled environment
where I would need to check out all the datasources I needed
trouble fellow teammates to check them in so I could do so!
I just decided to kill my IDE instead :)

0 comments: