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 | 843859 | 10 years ago
  1. 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
  2. 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
  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:125)
      2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
      3. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
      4. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:626)
      5. oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:113)
      6. oracle.jdbc.driver.T4CStatement.execute_for_rows(T4CStatement.java:561)
      7. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1081)
      8. oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1548)
      9. oracle.jdbc.xa.OracleXAResource.recover(OracleXAResource.java:503)
      9 frames
    3. weblogic.jdbc.wrapper
      VendorXAResource.recover
      1. weblogic.jdbc.wrapper.VendorXAResource.recover(VendorXAResource.java:82)
      1 frame
    4. weblogic.jdbc.jta
      DataSource.recover
      1. weblogic.jdbc.jta.DataSource.recover(DataSource.java:1241)
      1 frame
    5. weblogic.transaction.internal
      XAResourceDescriptor$1.execute
      1. weblogic.transaction.internal.XAServerResourceInfo.recover(XAServerResourceInfo.java:897)
      2. weblogic.transaction.internal.ServerSCInfo.recover(ServerSCInfo.java:515)
      3. weblogic.transaction.internal.XAResourceDescriptor.getXidsToBeRolledBack(XAResourceDescriptor.java:1310)
      4. weblogic.transaction.internal.XAResourceDescriptor.recover(XAResourceDescriptor.java:1247)
      5. weblogic.transaction.internal.XAResourceDescriptor.access$100(XAResourceDescriptor.java:57)
      6. weblogic.transaction.internal.XAResourceDescriptor$1.execute(XAResourceDescriptor.java:957)
      6 frames
    6. weblogic.kernel
      ExecuteThread.run
      1. weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:224)
      2. weblogic.kernel.ExecuteThread.run(ExecuteThread.java:183)
      2 frames