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 = 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( at oracle.jdbc.driver.T4CTTIoer.processError( at oracle.jdbc.driver.T4CTTIoer.processError( at oracle.jdbc.driver.T4C8Oall.receive( at oracle.jdbc.driver.T4CStatement.doOall8( at oracle.jdbc.driver.T4CStatement.executeForDescribe( at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe( at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe( at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout( at oracle.jdbc.driver.OracleStatement.executeQuery( at org.jboss.resource.adapter.jdbc.WrappedStatement.executeQuery( at org.dcm4chex.archive.ejb.jdbc.BaseReadCmd.execute( at org.dcm4chex.archive.ejb.jdbc.HPQueryCmd.execute( at org.dcm4chex.archive.dcm.hpscp.HPFindScp.doCFind( at at at org.dcm4cheri.util.LF_ThreadPool.join( at at org.dcm4cheri.server.DcmHandlerImpl.handle( at at org.dcm4cheri.util.LF_ThreadPool.join( at org.dcm4cheri.util.LF_ThreadPool$ at ]]></log4j:throwable> <log4j:properties> <log4j:data name="called" value="DCM4CHEE"/> <log4j:data name="calling" value="hgreens"/> <log4j:data name="ip" value=""/> </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 | 9 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
      1. oracle.jdbc.driver.DatabaseError.throwSqlException(
      2. oracle.jdbc.driver.T4CTTIoer.processError(
      3. oracle.jdbc.driver.T4CTTIoer.processError(
      4. oracle.jdbc.driver.T4C8Oall.receive(
      5. oracle.jdbc.driver.T4CStatement.doOall8(
      6. oracle.jdbc.driver.T4CStatement.executeForDescribe(
      7. oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(
      8. oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(
      9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
      10. oracle.jdbc.driver.OracleStatement.executeQuery(
      10 frames
      6 frames
    4. Unknown
      1. netwerk.main(
      1 frame