[mapserver-users] msOracleSpatialLayerGetShape(): OracleSpatial error. Error: ORA-00932

[dzizes]

Hi,

I've created a simple Oracle table, which contains NUMERIC id, SDO_GEOMETRY
shape and SDO_GEOM.SDO_CENTROID based on shape. There are spatial indexes on
both geometry columns.
GetMap requests are valid and I can see the map. However, when requesting a
GetFeatureInfo I receive:

Layer 'SHAPE'
Content-type: application/vnd.ogc.se_xml

<?xml version='1.0' encoding="ISO-8859-1" standalone="no" ?>
<!DOCTYPE ServiceExceptionReport SYSTEM
"http://schemas.opengis.net/wms/1.1.0/exception_1_1_0.dtd">
<ServiceExceptionReport version="1.1.0">
<ServiceException>
msOracleSpatialLayerGetShape(): OracleSpatial error. Error: ORA-00932:
inconsistent datatypes: expected %s got %s
 . Query statement: SELECT ID, GEO_CENTROID, GEOMETRIA FROM GEOM WHERE ID =
18746 .Check your data statement.
</ServiceException>
</ServiceExceptionReport>

below my WMS request:

http://localhost/cgi-bin/mapserv?map=/map/shape.map&service=WMS&VERSION=1.1&SRS=EPSG:4326&LAYERS=SHAPE&TRANSPARENT=true&FORMAT=image%2Fpng&REQUEST=GetFeatureInfo&STYLES=&EXCEPTIONS=application%2Fvnd.ogc.se_xml&BBOX=17.545968%2C51.146653%2C17.552216%2C51.151939&X=374&Y=146&INFO_FORMAT=mime&QUERY_LAYERS=SHAPE&WIDTH=656&HEIGHT=555

any help apriciated!

-- 
View this message in context: http://n2.nabble.com/msOracleSpatialLayerGetShape%28%29%3A-OracleSpatial-error.-Error%3A-ORA-00932-tp2268870p2268870.html
Sent from the Mapserver - User mailing list archive at Nabble.com.