Wednesday, May 27, 2015

ORA-04061: existing state of package body and ORA-04065: not executed


found below issue while compiling package by two different uses.
============================================
ORA-04061: existing state of package body "test.test_PKG" has been invalidated
ORA-04065: not executed, altered or dropped package body "test.test_PKG"
ORA-06508: PL/SQL: could not find program unit being called: "test.test_PKG" 9:53 PM
Caused by: org.springframework.jdbc.UncategorizedSQLException: CallableStatementCallback; uncategorized SQLException for SQL [{call TEST1_PKG.matchUpdatedInventory(?, ?, ?, ?, ?)}]; SQL state [72000]; ERROR code [4068]; ORA-04068: existing state of packages has been discarded
ORA-04061: existing state of package "TEST1.TEST1_PKG" has been invalidated
ORA-04065: not executed, altered or dropped package "TEST1.TEST1_PKG"
ORA-06508: PL/SQL: could not find program unit being called: "TEST1.TEST1_PKG"
ORA-06512: at line 1


Solution :

flushed shared pool fixed the issue.

cause: in the shared pool old compilation status was there. 

No comments:

Post a Comment