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
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  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 | 5 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