When accessing the Spatial Type for Oracle using SQL, the following error message is displayed:
ORA-04061: existing state of has been invalidated
ORA-04061: existing state of package body "SDE.ST_GEOMETRY_SHAPELIB_PKG" has been invalidated
ORA-06508: PL/SQL: could not find program unit being called
The name of the package body (SDE.ST_GEOMETRY_SHAPELIB_PKG) may be different from time to time, but the cause of the error is the same. The error number and format of the error message will not change.
Oracle has discovered a package or type body is invalid, and the object cannot be automatically recompiled. This issue has been identified on some Oracle servers where one database object has changed and has dependent database objects which become invalid.
SELECT OBJECT_NAME, OBJECT_TYPE
WHERE OBJECT_TYPE IN ('PACKAGE', 'PACKAGE BODY', 'TYPE', 'TYPE BODY')