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

Oracle Community | W. van Riel | 6 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

    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 | 10 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 | 1 year 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