java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00201: identifier 'SYS.DBMS_SYSTEM' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored

Oracle Community | 568046 | 1 decade ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    XA recover exception

    Oracle Community | 1 decade ago | 568046
    java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00201: identifier 'SYS.DBMS_SYSTEM' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored
  2. 0

    java.sql.SQLException: Numeric Overflow

    Oracle Community | 10 years ago | 843859
    java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00201: identifier 'SYS.DBMS_SYSTEM' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored

    Root Cause Analysis

    1. java.sql.SQLException

      ORA-06550: line 1, column 7: PLS-00201: identifier 'SYS.DBMS_SYSTEM' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored

      at oracle.jdbc.driver.DatabaseError.throwSqlException()
    2. Oracle jdbc
      OracleXAResource.recover
      1. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
      2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
      3. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
      4. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
      5. oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
      6. oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946)
      7. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
      8. oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1687)
      9. oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1653)
      10. oracle.jdbc.xa.OracleXAResource.recover(OracleXAResource.java:506)
      10 frames