6 Replies Latest reply: Feb 5, 2013 1:45 PM by 989315 RSS

    java.sql.SQLException: ORA-00933: SQL command not properly ended

    989315

      Hello everybody,
      I am trying to execute the following query but it raises an error

      java.sql.SQLException: ORA-00933: SQL command not properly ended


      The exact code for the query is
      con = getConnection(properties);
      prepPOIselectStmt = con.prepareStatement(
      "SELECT c.nn_node_id, c.name "+
      "FROM "+dbPOITableName+" c"+
      "WHERE SDO_INSIDE(c.geom,"+
      "SDO_GEOMETRY(2003, NULL, NULL,"+
      "SDO_ELEM_INFO_ARRAY(1,1003,3),"+
      "SDO_ORDINATE_ARRAY(?,?,?,?))) = 'TRUE';");

      Anyone has an advise?
      Thanks