java.sql.SQLException: ORA-00923: FROM keyword not found where expected

Oracle Community | 543828 | 9 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

    Is MapViewer 10.1.2 able to display 16bit grey scale images?

    Oracle Community | 9 years ago | 543828
    java.sql.SQLException: ORA-00923: FROM keyword not found where expected
  2. 0

    Limitation in MapViewer

    Oracle Community | 1 decade ago | 448590
    java.sql.SQLException: ORA-29903: error in executing ODCIIndexFetch() routine ORA-13236: internal error in R-tree processing: [] ORA-13236: internal error in R-tree processing: [Recursive fetch error]
  3. 0

    ORA-29902, ORA-13203,ORA-29400

    Oracle Community | 1 decade ago | 440705
    java.sql.SQLException: ORA-29902: error in executing ODCIIndexStart() routine ORA-13203: failed to read USER_SDO_GEOM_METADATA view ORA-13203: failed to read USER_SDO_GEOM_METADATA view ORA-29400: data cartridge error ORA-04031: unable to allocate 76 bytes of shared memory ("shared pool","SELECT diminfo, nvl(srid,-1)...","Typecheck","qksxaAddList:xa") ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 286
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    MapViewer with data from multiple schemas

    Oracle Community | 10 years ago | 578019
    java.sql.SQLException: ORA-29902: error in executing ODCIIndexStart() routine ORA-13208: internal error while evaluating [window SRID does not match layer SRID] operator ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 286
  6. 0

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

    oracle.com | 11 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)

    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-00923: FROM keyword not found where expected

      at oracle.jdbc.driver.DatabaseError.throwSqlException()
    2. Oracle jdbc
      OraclePreparedStatement.executeQuery
      1. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:137)
      2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:315)
      3. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:281)
      4. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:638)
      5. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:184)
      6. oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:502)
      7. oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:1028)
      8. oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:534)
      9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1125)
      10. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3000)
      11. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3042)
      11 frames
    3. oracle.sdovis.theme
      PredGeomThemeProducer.prepareData
      1. oracle.sdovis.theme.PredGeomThemeProducer.loadFeaturesInWindow(PredGeomThemeProducer.java:498)
      2. oracle.sdovis.theme.PredGeomThemeProducer.prepareData(PredGeomThemeProducer.java:229)
      2 frames
    4. oracle.sdovis
      DBMapMaker$LoadThemeData.run
      1. oracle.sdovis.Theme.prepareData(Theme.java:174)
      2. oracle.sdovis.DBMapMaker$LoadThemeData.run(DBMapMaker.java:1740)
      2 frames