I am running my web application WAR in WebLogic 12c. I configured my JNDI JDBC Data Source using Data Source option at admin console. Everything was working fine until I removed some privileges from stored procedures. After that I am getting error ORA-04068: existing state of packages string has been discarded.
But nothing is able to solve the issue. Could any one please suggest me any resolution to the above issue ? Any help would be appreciated.
1. Clear the statement cache in webLogic
2. Reset the connection in webLogic
3. Set Statement Cache Size to 0
4. Finally restart the server using command line
5. Deleted the conflicting package
Finally I am able to solve this issue. It was because of timestamp mismatch error in Oracle Database. Resolution found here