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

[umn-ms at hydrotec.de]

Hi

I think you shouldn't query 2 geometry-columns at once 
Either
DATA "GEOMETRIA FROM (SELECT ID, GEOMETRIA FROM GEOM) USING UNIQUE ID SRID 
XYZ"
or
DATA "GEO_CENTROID FROM (SELECT ID, GEO_CENTROID FROM GEOM) USING UNIQUE 
ID SRID XYZ"

If you want to have the Centerpoint in Getfeatureinfo you may try:
DATA "GEOMETRIA FROM (SELECT ID,  GEOMETRIA, GEO_CENTROID.SDO_POINT.X, 
GEO_CENTROID.SDO_POINT.Y  FROM GEOM) USING UNIQUE ID SRID XYZ"

Bye
Benedikt Rothe

mapserver-users-bounces at lists.osgeo.org schrieb am 04.02.2009 14:58:02:

> 
> 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.
> 
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20090204/9bdf6368/attachment.htm>