java.sql.SQLException: ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table ORA-02063: preceding line from DB-LINK-NAME

Oracle Community | 603540 | 8 years ago
  1. 0

    MapBuilder does not work with DB-link in a spatial view

    Oracle Community | 8 years ago | 603540
    java.sql.SQLException: ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table ORA-02063: preceding line from DB-LINK-NAME
  2. 0

    ORA-06553: PLS-907: cannot load library unit MD... | Oracle Community

    oracle.com | 8 months ago
    java.sql.SQLException: ORA-29900: operator binding does not exist ORA-06540: PL/SQL: compilation error ORA-06553: PLS-907: cannot load library unit MDSYS.SDO_3GL (referenced by MDSYS.SDO_FILTER)
  3. 0

    Oracle Maps RC1 - java.sql.SQLException: No more data to read from socket

    Oracle Community | 1 decade ago | BranislavNemec
    java.sql.SQLException: OALL8 is in an inconsistent state.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    ORA-06553: PLS-907: cannot load library unit MDSYS.SDO-3GL

    Oracle Community | 9 years ago | 564551
    java.sql.SQLException: ORA-29900: operator binding does not exist ORA-06540: PL/SQL: compilation error ORA-06553: PLS-907: cannot load library unit MDSYS.SDO_3GL (referenced by MDSYS.SDO_FILTER)
  6. 0

    import shapefile from Map Builder got errors

    Oracle Community | 9 years ago | 564551
    java.sql.SQLException: ORA-13226: interface not supported without a spatial index ORA-06512: at "MDSYS.MD", line 1723 ORA-06512: at "MDSYS.MDERR", line 8 ORA-06512: at "MDSYS.SDO_3GL", line 529

    12 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-01445: cannot select ROWID from, or sample, a join view without a key-preserved table ORA-02063: preceding line from DB-LINK-NAME

      at oracle.jdbc.driver.DatabaseError.throwSqlException()
    2. Oracle jdbc
      OraclePreparedStatement.executeQuery
      1. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
      2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)
      3. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)
      4. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:744)
      5. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)
      6. oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:809)
      7. oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1038)
      8. oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:849)
      9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1133)
      10. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3338)
      11. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3383)
      11 frames
    3. oracle.sdovis.theme
      PredGeomThemeProducer.prepareData
      1. oracle.sdovis.theme.PredGeomThemeProducer.loadFeaturesInWindow(PredGeomThemeProducer.java:701)
      2. oracle.sdovis.theme.PredGeomThemeProducer.prepareData(PredGeomThemeProducer.java:235)
      2 frames
    4. oracle.sdovis
      LoadThemeData.run
      1. oracle.sdovis.Theme.prepareData(Theme.java:184)
      2. oracle.sdovis.LoadThemeData.run(LoadThemeData.java:75)
      2 frames