-- Steps to reproduce problem CREATE TABLE GEOMS ( id NUMBER(10,0) NOT NULL, GEOMETRY SDO_GEOMETRY NOT NULL ); INSERT INTO USER_SDO_GEOM_METADATA VALUES ( 'GEOMS', -- TABLE_NAME 'GEOMETRY', -- COLUMN_NAME SDO_DIM_ARRAY -- DIMINFO attribute for storing dimension bounds, tolerance ( SDO_DIM_ELEMENT ( 'LONGITUDE', -- DIMENSION NAME for first dimension -180, -- SDO_LB for the dimension 180, -- SDO_UB for the dimension 0.5 -- Tolerance of 0.5 meters ), SDO_DIM_ELEMENT ( 'LATITUDE', -- DIMENSION NAME for second dimension -90, -- SDO_LB for the dimension 90, -- SDO_UB for the dimension 0.5 -- Tolerance of 0.5 meters ) ), 4326 -- SRID value for specifying a geodetic coordinate system ); INSERT INTO GEOMS VALUES ( '3', SDO_GEOMETRY ( 2003, -- SDO_GTYPE format: D00T. Set to 2005 5 = Multipoint 4326, -- SDO_SRID NULL, -- SDO_POINT attribute set to NULL SDO_ELEM_INFO_ARRAY -- SDO_ELEM_INFO attribute (see Table 4-2 for values) ( 1, -- Offset is 1 1003, -- For polygons, the element-type is 1003 (the T value in SDO_GTYPE is 3). 1 -- For line strings and polygons, the interpretation is 1 if the connectivity is by straight lines ), SDO_ORDINATE_ARRAY -- SDO_ORDINATES attribute ( -77.04487, 38.9043742, -- coordinates of first vertex -77.046645, 38.9040983, -- other vertices -77.04815, 38.9033127, -77.049155, 38.9021368, -77.049508, 38.9007499, -77.049155, 38.899363, -77.048149, 38.8981873, -77.046645, 38.8974017, -77.04487, 38.8971258, -77.043095, 38.8974017, -77.041591, 38.8981873, -77.040585, 38.899363, -77.040232, 38.9007499, -77.040585, 38.9021368, -77.04159, 38.9033127, -77.043095, 38.9040983, -77.04487, 38.9043742 -- coordinates of last vertex same as first vertex ) ) ); SELECT SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT(a.geometry, 0.5) is_valid FROM GEOMS a WHERE a.id=3; Returns TRUE; CREATE INDEX MESSAGE_GEOMS_GEOMETRY ON GEOMS ( "GEOMETRY" ) INDEXTYPE IS "MDSYS"."SPATIAL_INDEX" ; CREATE OR REPLACE FORCE VIEW GEOMS_LAYER ("ID", "GEOMETRY") AS SELECT geoms.id, geoms.GEOMETRY AS geometry FROM geoms WHERE geoms.id != 0; When I create the layer the Native SRS isn't populated by default. So I hand-jam into the Declared SRS to EPSG:4326. I set both Bounding Boxes to -180 -90 180 90 and save. This returns the record. http://localhost:8080/geoserver/wfs?request=GetFeature&typeName=GEOMS_LAYER&maxFeatures=10 This explodes... GEOMETRY -180 -90 180 90 EXCEPTION TEXT! - - java.lang.RuntimeException: java.io.IOException java.io.IOException null 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