[mapserver-dev] msOracleSpatialLayerWhichShapes(): OracleSpatial error

[Pano Voudouris]

I think you hit the same problem as I did. See:-
http://osgeo-org.1803224.n2.nabble.com/DrawQuery-with-Oracle-Spatial-RFC-52-
td4962851.html#a4962851. No replies as yet!

I have a workaround for this (and at the same time enhanced the
functionality as per ticket 3190
http://trac.osgeo.org/mapserver/ticket/3190) described in my blog:
http://mapoholic.wordpress.com/2010/04/10/drawing-selected-features-in-mapse
rver-with-mapscript/

Hope this helps.
Pano


-----Original Message-----
From: mapserver-dev-bounces at lists.osgeo.org
[mailto:mapserver-dev-bounces at lists.osgeo.org] On Behalf Of Agostino
Sent: 14 May 2010 02:42
To: mapserver-dev at lists.osgeo.org
Subject: [mapserver-dev] msOracleSpatialLayerWhichShapes(): OracleSpatial
error


I'm using mapscript c# (mapserver 5.6.3)

I want to highlight an element in my map and this is what i write

layerObj lo = map.getLayer(i);
lo.queryByAttributes(map, null, strQuery, mapscript.MS_MULTIPLE);
map.drawQuery();  <--- The map image is generated with the highlighted
element.

After i want to to clear my query and my code is:
map.freeQuery(-1);
map.drawQuery();  <--- throw error

msOracleSpatialLayerWhichShapes(): OracleSpatial error. Error: ORA-00600:
codice di errore interno, argomenti: [17182], [0x2581CE802], [], [], [], [],
[], []
 . Query statement: SELECT ID, GEOMETRY FROM AAAMAMCOMU WHERE SDO_FILTER(
GEOMETRY, MDSYS.SDO_GEOMETRY(2003, :srid,
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates ),'querytype=window') =
'TRUE' . Check your data statement.
[Thu May 13 18:52:46 2010].621000 msDrawMap(): Image handling error. Failed
to draw layer named 'Limiti Comunali'.

With mapserver 5.4 my code is ok.

Thank you
Agostino.



-- 
View this message in context:
http://osgeo-org.1803224.n2.nabble.com/msOracleSpatialLayerWhichShapes-Oracl
eSpatial-error-tp5048864p5048864.html
Sent from the Mapserver - Dev mailing list archive at Nabble.com.
_______________________________________________
mapserver-dev mailing list
mapserver-dev at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-dev