java.sql.SQLException: ORA-04068: existing state of packages has been discarded ORA-04065: not executed, altered or dropped stored procedure "APOLLO_TEST.PKG_APL_POLICY" ORA-06508: PL/SQL: could not find program unit being called: "APOLLO_TEST.PKG_APL_POLICY" ORA-06512: at line 1 at oracle.jdbc.driver.DatabaseError.throwSqlException(Ljava.lang.String;Ljava.lang.String;I)V(DatabaseError.java:112) at oracle.jdbc.driver.T4CTTIoer.processError(ZLoracle.jdbc.driver.OracleStatement;)V(T4CTTIoer.java :331) at oracle.jdbc.driver.T4CTTIoer.processError(Loracle.jdbc.driver.OracleStatement;)V(T4CTTIoer.java:288) at oracle.jdbc.driver.T4C8Oall.receive() V(T4C8Oall.java:743) at oracle.jdbc.driver.T4CCallableStatement.doOall8 (ZZZZ) V(T4CCallableStatement.java:215)

Oracle Community | A.D. | 1 decade ago
  1. 0

    ACE members!!plz help!! its urgent!!

    Oracle Community | 1 decade ago | A.D.
    java.sql.SQLException: ORA-04068: existing state of packages has been discarded ORA-04065: not executed, altered or dropped stored procedure "APOLLO_TEST.PKG_APL_POLICY" ORA-06508: PL/SQL: could not find program unit being called: "APOLLO_TEST.PKG_APL_POLICY" ORA-06512: at line 1 at oracle.jdbc.driver.DatabaseError.throwSqlException(Ljava.lang.String;Ljava.lang.String;I)V(DatabaseError.java:112) at oracle.jdbc.driver.T4CTTIoer.processError(ZLoracle.jdbc.driver.OracleStatement;)V(T4CTTIoer.java :331) at oracle.jdbc.driver.T4CTTIoer.processError(Loracle.jdbc.driver.OracleStatement;)V(T4CTTIoer.java:288) at oracle.jdbc.driver.T4C8Oall.receive() V(T4C8Oall.java:743) at oracle.jdbc.driver.T4CCallableStatement.doOall8 (ZZZZ) V(T4CCallableStatement.java:215)
  2. 0

    Problem with callable statement.....Pls help

    Oracle Community | 1 decade ago | 807607
    java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00905: object HR.SHOW_SUPPLIER12 is invalid ORA-06550: line 1, column 7: PL/SQL: Statement ignored
  3. 0

    Export Failure from Publisher Export Wizard in BPA 11gR1

    Oracle Community | 6 years ago | 806900
    com.idsscheer.aris.businesspublisher.application.dao.ADAOException: ADAOException
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Error "ORA-04065: .... "APPS.AME_UTIL"" when submiting self-service request

    Oracle Community | 4 years ago | User353235
    java.sql.SQLException: ORA-04068: existing state of packages has been discarded ORA-04065: not executed, altered or dropped stored procedure "APPS.AME_UTIL" ORA-06508: PL/SQL: could not find program unit being called: "APPS.AME_UTIL" ORA-06512: at "APPS.AME_DYNAMIC_APPROVAL_PKG", line 509 ORA-04065: not executed, altered or dropped stored procedure "APPS.AME_UTIL" ORA-06508: PL/SQL: could not find program unit being called: "APPS.AME_UTIL" ORA-06512: at line 1at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
  6. 0

    setQueryTimeout does not seem to work...

    Oracle Community | 9 years ago | 417671
    java.sql.SQLException: ORA-01013: user requested cancel of current operation ORA-06512: at "SYS.DBMS_LOCK", line 201 ORA-06512: at "WLPDEV.SLOW_QUERY", line 6 at oracle.jdbc.driver.DatabaseError.throwSqlException(Ljava/lang/String;Ljava/lang/String;I)V(DatabaseError.java:112) at oracle.jdbc.driver.T4CTTIoer.processError(ZLoracle/jdbc/driver/OracleStatement;)V(T4CTTIoer.java:331) at oracle.jdbc.driver.T4CTTIoer.processError(Loracle/jdbc/driver/OracleStatement;)V(T4CTTIoer.java:288) at oracle.jdbc.driver.T4C8Oall.receive() V(T4C8Oall.java:743)

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      ORA-04068: existing state of packages has been discarded ORA-04065: not executed, altered or dropped stored procedure "APOLLO_TEST.PKG_APL_POLICY" ORA-06508: PL/SQL: could not find program unit being called: "APOLLO_TEST.PKG_APL_POLICY" ORA-06512: at line 1 at oracle.jdbc.driver.DatabaseError.throwSqlException(Ljava.lang.String;Ljava.lang.String;I)V(DatabaseError.java:112) at oracle.jdbc.driver.T4CTTIoer.processError(ZLoracle.jdbc.driver.OracleStatement;)V(T4CTTIoer.java :331) at oracle.jdbc.driver.T4CTTIoer.processError(Loracle.jdbc.driver.OracleStatement;)V(T4CTTIoer.java:288) at oracle.jdbc.driver.T4C8Oall.receive() V(T4C8Oall.java:743) at oracle.jdbc.driver.T4CCallableStatement.doOall8 (ZZZZ) V(T4CCallableStatement.java:215)

      at oracle.jdbc.driver.T4CCallableStatement.executeForRows()
    2. Oracle jdbc
      T4CCallableStatement.executeForRows
      1. oracle.jdbc.driver.T4CCallableStatement.executeForRows(Z)
      1 frame