[mapserver-users] Oracle spatial issue

[Murty Maganti]

Hi All,

 

I am using some oracle spatial layers, getting this error while
refreshing map for some of the layers 

 

Image handling error. Failed to draw layer named
'Landformarea'.;msOracleSpatialLayerWhichShapes(): OracleSpatial error.
Error: ORA-01002: fetch out of sequence

 . Query statement: SELECT OBJECTID_1, SURFACETYPE, GEOM FROM
ALAIN.LANDFORMAREA WHERE SDO_FILTER( GEOM, MDSYS.SDO_GEOMETRY(2003,
32640,
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(363076
.413,2679613.84,364442.736,2680338.91) ),'querytype=window') = 'TRUE' .
Check your data statement.

 

 

When does this 'fetch out of sequence' error is thrown by oracle. How
can I resolve the issue.

 

Appreciate help.

 

Thanks

Murty

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20091109/a400a9c4/attachment.htm>