Global Exception

Sorry! Error has occured. Something went wrong

Reason: org.springframework.jdbc.UncategorizedSQLException: CallableStatementCallback; uncategorized SQLException for SQL [{call FL_COMMON_PKG.GET_COMMON_PAGE_CONTENT_PRC(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)}]; SQL state [72000]; error code [4068]; ORA-04068: existing state of packages has been discarded ORA-04061: existing state of package body "HOT_FLIGHT.FL_SEARCH_PKG" has been invalidated ORA-04065: not executed, altered or dropped package body "HOT_FLIGHT.FL_SEARCH_PKG" ORA-06508: PL/SQL: could not find program unit being called: "HOT_FLIGHT.FL_SEARCH_PKG" ORA-06512: at "HOT_FLIGHT.FL_COMMON_PKG", line 222 ORA-06512: at "HOT_FLIGHT.FL_COMMON_PKG", line 65 ORA-06512: at line 1 ; nested exception is java.sql.SQLException: ORA-04068: existing state of packages has been discarded ORA-04061: existing state of package body "HOT_FLIGHT.FL_SEARCH_PKG" has been invalidated ORA-04065: not executed, altered or dropped package body "HOT_FLIGHT.FL_SEARCH_PKG" ORA-06508: PL/SQL: could not find program unit being called: "HOT_FLIGHT.FL_SEARCH_PKG" ORA-06512: at "HOT_FLIGHT.FL_COMMON_PKG", line 222 ORA-06512: at "HOT_FLIGHT.FL_COMMON_PKG", line 65 ORA-06512: at line 1 at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:1094) at org.springframework.jdbc.core.JdbcTemplate.call(JdbcTemplate.java:1130) at org.springframework.jdbc.object.StoredProcedure.execute(StoredProcedure.java:142) at com.floodlight.site.dao.sp.common.CommonContentsSP.executeProcedure(CommonContentsSP.java:100) at com.floodlight.site.dao.impl.CommonDAOImpl.getCommonContents(CommonDAOImpl.java:24) at com.floodlight.site.business.impl.CommonBusinessImpl.getCommonContents(CommonBusinessImpl.java:18) at com.floodlight.site.util.seo.SeoUtils.setCommonContents(SeoUtils.java:91) at com.floodlight.site.util.common.CommonPageContents.loadCommonPageContents(CommonPageContents.java:22) at com.floodlight.site.controller.course.SearchResultsController.getSearchResults(SearchResultsController.java:453) at sun.reflect.GeneratedMethodAccessor568.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:178) at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:442) at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:430) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861) at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846) at javax.servlet.http.HttpServlet.service(HttpServlet.java:844) at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:280) at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:254) at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:136) at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:346) at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79) at com.floodlight.util.filter.CampaignIdFilter.doFilter(CampaignIdFilter.java:27) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79) at com.floodlight.util.filter.TrackSessionIdFilter.doFilter(TrackSessionIdFilter.java:49) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79) at com.floodlight.util.filter.CookieFilter.doFilter(CookieFilter.java:45) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79) at com.floodlight.util.filter.CacheControlFilter.doFilter(CacheControlFilter.java:28) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79) at com.floodlight.util.filter.RequestEncodeFilter.doFilter(RequestEncodeFilter.java:21) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79) at com.cj.trim.trimFilter.doFilter(Unknown Source) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3436) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3402) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120) at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:57) at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2285) at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2201) at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179) at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1572) at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:255) at weblogic.work.ExecuteThread.execute(ExecuteThread.java:311) at weblogic.work.ExecuteThread.run(ExecuteThread.java:263) Caused by: java.sql.SQLException: ORA-04068: existing state of packages has been discarded ORA-04061: existing state of package body "HOT_FLIGHT.FL_SEARCH_PKG" has been invalidated ORA-04065: not executed, altered or dropped package body "HOT_FLIGHT.FL_SEARCH_PKG" ORA-06508: PL/SQL: could not find program unit being called: "HOT_FLIGHT.FL_SEARCH_PKG" ORA-06512: at "HOT_FLIGHT.FL_COMMON_PKG", line 222 ORA-06512: at "HOT_FLIGHT.FL_COMMON_PKG", line 65 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587) at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:220) at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:48) at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:938) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1150) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:4901) at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:5631) at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1385) at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:105) at org.springframework.jdbc.core.JdbcTemplate$6.doInCallableStatement(JdbcTemplate.java:1133) at org.springframework.jdbc.core.JdbcTemplate$6.doInCallableStatement(JdbcTemplate.java:1130) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:1078) ... 51 more