[mapserver-users] Mapserver 7+oracle - wfs getFeature with filter on numeric field

[Steve.Toutant at inspq.qc.ca]

I have a problem using a FILTER in a wfs getFeature request on an oracle 
DB with MS7
When I launch a getFeature request with a Filter on a numeric field it 
doesn't work, 
<ogc:Filter xmlns:ogc="http://www.opengis.net/ogc"><ogc:PropertyIsEqualTo 
matchCase="false"><ogc:PropertyName>LONG_STAT</ogc:PropertyName><ogc:Literal>-61</ogc:Literal></ogc:PropertyIsEqualTo></ogc:Filter> 

here is the error we get in the browser
<ows:Exception exceptionCode="NoApplicableCode" locator="mapserv">
   <ows:ExceptionText>msWFSGetFeature(): WFS server error. 
FLTApplyFilterToLayer() failed
msOracleSpatialLayerWhichShapes(): OracleSpatial error. Check your data 
statement and server logs</ows:ExceptionText> 

from mapserver logs
[Tue May 12 11:59:10 2015].177992 msOracleSpatialLayerTranslateFilter. 
String:  ([LONG_STAT] =*-61)  

LONG_STAT is a NUMBER in the DB
DescribefeatureType returns
          <element name="NO_STAT_CLIM" minOccurs="0" type="string"/>
         <element name="NO_STAT_FADQ" minOccurs="0" type="string"/>
         <element name="NOM_STAT" minOccurs="0" type="string"/>
         <element name="LATI_STAT" minOccurs="0" type="string"/>
         <element name="LONG_STAT" minOccurs="0" type="string"/>
         <element name="ALTI_STAT" minOccurs="0" type="string"/> 

I tried to add "gml_types" "auto" in the mapfile, but it still returns 
string as data type
I tried "gml_LONG_STAT_type" = "Integer" in the mapfile, 
describeFeatureType returns "<element name="LONG_STAT" minOccurs="0" 
type="double"/> " but I still get an error in getFeature

I'm using CONNECTIONTYPE oraclespatial in the mapfile

I can provide more information....

Is it a known issue or can I do something about that?

Thank you!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20150512/edfd7ba3/attachment.htm>