java.sql.SQLException: ORA-22905: cannot access rows from a non-nested table item

Oracle Community | W. van Riel | 6 years ago
  1. 0

    cannot load network data

    Oracle Community | 6 years ago | W. van Riel
    java.sql.SQLException: ORA-22905: cannot access rows from a non-nested table item
  2. 0

    Network error

    Oracle Community | 1 decade ago | 466632
    java.sql.SQLException: ORA-00936: missing expression ORA-06512: at "MDSYS.SDO_NET", line 2044
  3. 0

    {code:xml} <log4j:event logger="org.dcm4chex.archive.ejb.jdbc.BaseCmd" timestamp="1184784717500" level="WARN" thread="TCPServer-2-2"> <log4j:message><![CDATA[failed to execute sql: SELECT DISTINCT hp.hp_attrs FROM hp, hpdef WHERE hp.pk = hpdef.hp_fk(+) - retry: 1 of 20]]></log4j:message> <log4j:throwable><![CDATA[java.sql.SQLException: ORA-00932: inconsistent datatypes: expected - got BLOB at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:790) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1031) at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:830) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1124) at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1264) at org.jboss.resource.adapter.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:171) at org.dcm4chex.archive.ejb.jdbc.BaseReadCmd.execute(BaseReadCmd.java:85) at org.dcm4chex.archive.ejb.jdbc.HPQueryCmd.execute(HPQueryCmd.java:191) at org.dcm4chex.archive.dcm.hpscp.HPFindScp.doCFind(HPFindScp.java:83) at org.dcm4che.net.DcmServiceBase.c_find(DcmServiceBase.java:152) at org.dcm4cheri.net.ActiveAssociationImpl.run(ActiveAssociationImpl.java:225) at org.dcm4cheri.util.LF_ThreadPool.join(LF_ThreadPool.java:174) at org.dcm4cheri.net.ActiveAssociationImpl.run(ActiveAssociationImpl.java:148) at org.dcm4cheri.server.DcmHandlerImpl.handle(DcmHandlerImpl.java:249) at org.dcm4cheri.server.ServerImpl.run(ServerImpl.java:263) at org.dcm4cheri.util.LF_ThreadPool.join(LF_ThreadPool.java:174) at org.dcm4cheri.util.LF_ThreadPool$1.run(LF_ThreadPool.java:221) at java.lang.Thread.run(Thread.java:595) ]]></log4j:throwable> <log4j:properties> <log4j:data name="called" value="DCM4CHEE"/> <log4j:data name="calling" value="hgreens"/> <log4j:data name="ip" value="10.237.225.235"/> </log4j:properties> </log4j:event> {code} Cause: Oracle does not support using DISTINCT with a blob data type! Solution: Refactor Left Join to sub-query as done for Composite Object Query [DCMEE-375]

    JIRA | 9 years ago | Tim Collins
    java.sql.SQLException: ORA-00932: inconsistent datatypes: expected - got BLOB
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Pessimistic Locking Problem

    Oracle Community | 9 years ago | 604165
    java.sql.SQLException: ORA-01747: invalid user.table.column, table.column, or columns
  6. 0

    Select the Oracle java - ORA-00905: not found keyword

    Stack Overflow | 11 months ago | Paulo Silva
    java.sql.SQLException: ORA-00905: not found keyword

    1 unregistered visitors
    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-22905: cannot access rows from a non-nested table item

      at oracle.jdbc.driver.DatabaseError.throwSqlException()
    2. Oracle jdbc
      OracleStatement.executeQuery
      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.executeForDescribe(T4CStatement.java:790)
      7. oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1031)
      8. oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:830)
      9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1124)
      10. oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1264)
      10 frames
    3. oracle.spatial.network
      NetworkManager.readNetwork
      1. oracle.spatial.network.GeometryMetadata.<init>(GeometryMetadata.java:112)
      2. oracle.spatial.network.NetworkMetadataImpl.<init>(NetworkMetadataImpl.java:314)
      3. oracle.spatial.network.NetworkAdapterSDO.readNetworkMetadata(NetworkAdapterSDO.java:6444)
      4. oracle.spatial.network.NetworkAdapterSDO.readNetwork(NetworkAdapterSDO.java:449)
      5. oracle.spatial.network.NetworkAdapterSDO.readNetwork(NetworkAdapterSDO.java:268)
      6. oracle.spatial.network.NetworkManager.readNetwork(NetworkManager.java:136)
      6 frames
    4. Unknown
      netwerk.main
      1. netwerk.main(netwerk.java:88)
      1 frame