<div>Hi there,</div>
<div> </div>
<div>I am trying to render the map with oracle spatial database, and facing problems with the FILTER expression.</div>
<div> </div>
<div>at first I define the oracle spatial connection like:</div>
<div> </div>
<div>CONNECTIONTYPE ORACLESPATIAL<br>CONNECTION "<a href="mailto:E110/E110@PMCGIS2.WORLD">E110/E110@PMCGIS2.WORLD</a>"<br>DATA "GEOLOC FROM E112_CELLS_GEO USING UNIQUE MI_PRINX SRID 8307"</div>
<div> </div>
<div>and this one works fine, therefore I am sure that the mapfile definition is ok, and then I change the data connection to :</div>
<div> </div>
<div>CONNECTIONTYPE ORACLESPATIAL<br>CONNECTION "<a href="mailto:E110/E110@PMCGIS2.WORLD">E110/E110@PMCGIS2.WORLD</a>"<br>DATA "GEOLOC FROM E112_CELLS_GEO USING FILTER"<br>FILTER "WHERE MI_PRINX =100"
</div>
<div> </div>
<div>to use the FILTER function for a specific selection, but this definition gives aan error instead of the map image:</div>
<div> </div>
<div>ERROR:</div>
<div>msOracleSpatialLayerWhichShapes(): OracleSpatial error. Error: ORA-00936: missing expression . </div>
<div>Query statement: SELECT rownum, GEOLOC FROM E112_CELLS_GEO WHERE WHERE MI_PRI<br>NX=100 AND SDO_FILTER( GEOLOC, MDSYS.SDO_GEOMETRY(2003, NULL, NULL,MDSYS.SDO_ELE<br>M_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(5.95587
,45.11214,10.49203,48.514<br>26) ),'querytype=window') = 'TRUE' . </div>
<div>Check your data statement.</div>
<div> </div>
<div>I can not figure out where the problem is. the MI_PRINX is the unique id of the table, if I make this query in the SQLPlus, the data will be returned, which means the where condition in the SQL is no problem.</div>
<div> </div>
<div>any ideas for this?</div>
<div> </div>
<div>kind regards</div>
<div> </div>
<div>zhonghai</div>
<div> </div>
<div> </div>
<div> </div>
<div> </div>
<div> </div>