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 | 10 years ago
  1. 0

    XA recover exception

    Oracle Community | 10 years 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
  3. 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
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    How to grant rights to users for a procedure in a package

    Oracle Community | 1 decade ago | 440495
    java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00201: identifier 'BACKFLUSH_PKG.INSERT_MOTO_WYATT_FCS_BCKFS' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored
  6. 0

    Exception in thread main java-sql-SQLException: ORA-06550: line 1, column 7: | 4409 - javatpoint.com

    javatpoint.com | 1 year ago
    java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00201: identifier 'INSERTR' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored

    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-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