java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at "MDSYS.SDO_3GL", line 1320

Oracle Community | user10750794 | 7 years ago
  1. 0

    sdo_filter error while trying to do results paging

    Oracle Community | 7 years ago | user10750794
    java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at "MDSYS.SDO_3GL", line 1320
  2. 0

    Oracle下使用出现ora-01780问题

    GitHub | 5 years ago | pangwu86
    org.nutz.dao.DaoException: org.nutz.dao.DaoException: !Nutz SQL Error: 'COMMENT ON TABLE t_twc IS '测试表'' PreparedStatement: 'COMMENT ON TABLE t_twc IS ?'
  3. 0

    Blob字段处理

    GitHub | 4 years ago | aodixiaoqiang
    java.sql.SQLException: ORA-01465: 无效的十六进制数字
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Select with OracleDriver

    Google Groups | 6 years ago | SVoigt
    java.sql.SQLException: ORA-00942: table or view does not exist
  6. 0

    BLOB + MyBatis

    Google Groups | 6 years ago | vkrejcirik
    java.sql.SQLException: ORA-00932: inconsistent datatypes: expected - got BLOB ; bad SQL grammar []; nested exception is java.sql.SQLException: ORA-00932: inconsistent datatypes: expected - got BLOB

    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-01422: exact fetch returns more than requested number of rows ORA-06512: at "MDSYS.SDO_3GL", line 1320

      at oracle.jdbc.driver.DatabaseError.throwSqlException()
    2. Oracle jdbc
      OraclePreparedStatement.execute
      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.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
      6. oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
      7. oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1062)
      8. oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:839)
      9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132)
      10. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
      11. oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3390)
      11 frames
    3. Unknown
      QueryTester.main
      1. QueryTester.main(QueryTester.java:61)
      1 frame