ORA-06550 Error found in TOMCAT Logs
We are facing an issue in production. Our application environment is mentioned as below:
Front end Apps : JAVA Code
Application Server : TOMCAT
DB : Oracle 11g R1 (11.1.0.7) in RAC environment
Our IVR application (written in JAVA) calling the below oracle package and its working fine 99% of callers. But some of the callers it's throwing an below mentioned error and this error captured in TOMCAT logs.
java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00201: identifier 'DOCOMO_IVR_POS_PKG.SP_GET_CALLER_DETAILS' must be declared
java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00201: identifier 'ACE.RQST_GSM_IVR_PKG' must be declared