ora-04061 是 Oracle 数据库中的一个常见错误,具体错误信息为 "existing state of packages has been discarded"。这个错误通常与 PL/SQL 包(Package)的状态有关,当尝试使用或重新编译一个包,但其状态已被废弃或重置时,就会发生此错误。 可能的原因 包被显式重置:使用 ALTER PACKAGE <package_name> COMP...
ORA-04061: existing state of package body "APPS.<some package>" has been invalidated ORA-04065: not executed, altered or dropped package body... I've recompiled the package/body, cleared the share pool, etc., but the error persists. There is no invalid object in dba_objects either. What...
Can you please let me know how to avoid this error.Error Message: ORA-04068: existing state of packages has been discarded ORA-04061 Thanks Ram
这仅指ORA-04068，但ORA-04061属于同一类问题。我认为你可能有一个连接池的原因是错误并不总是发生，...
Can you please let me know how to avoid this error.Error Message: ORA-04068: existing state of packages has been discarded ORA-04061 Thanks Ram
ORA-04061: existing state of package body "APPS.<some package>" has been invalidated ORA-04065: not executed, altered or dropped package body... I've recompiled the package/body, cleared the share pool, etc., but the error persists. There is no invalid object in dba_objects either. ...
Can you please let me know how to avoid this error.Error Message: ORA-04068: existing state of packages has been discarded ORA-04061 Thanks Ram