<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Segoe UI";
panose-1:2 11 5 2 4 2 4 2 2 3;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma",sans-serif;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Segoe UI",sans-serif;}
p.Seliteteksti, li.Seliteteksti, div.Seliteteksti
{mso-style-name:Seliteteksti;
mso-style-link:"Seliteteksti Char";
margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.SelitetekstiChar
{mso-style-name:"Seliteteksti Char";
mso-style-priority:99;
mso-style-link:Seliteteksti;
font-family:"Tahoma",sans-serif;}
span.EmailStyle22
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EmailStyle23
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.pl-s
{mso-style-name:pl-s;}
span.pl-pds
{mso-style-name:pl-pds;}
span.EmailStyle26
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">This isn’t limited to Oracle… I would expect Postgres and native MapServer to have similar issues.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> Smith, Michael ERDC-RDE-CRREL-NH [mailto:Michael.Smith@erdc.dren.mil]
<br>
<b>Sent:</b> Tuesday, May 19, 2015 4:21 PM<br>
<b>To:</b> Rahkonen Jukka (MML); Lime, Steve D (MNIT); Steve.Toutant@inspq.qc.ca; MapserverList OSGEO<br>
<b>Cc:</b> Michael.Smith@erdc.dren.mi<br>
<b>Subject:</b> Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs getFeature with filter on numeric field<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Calibri",sans-serif;color:black">Jukka,<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Calibri",sans-serif;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Calibri",sans-serif;color:black">The issue is not only the NLS format, which would govern the output and how the sql is interpreted, but there is also the issue of the lexer which is reading the
xml request. And that would have to change also. <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Calibri",sans-serif;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Calibri",sans-serif;color:black">Its also unclear to me if XML / WFS allows other characters as a decimal character. I've yet to find any xsd or guide docs that indicate one way or the other. <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Calibri",sans-serif;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Calibri",sans-serif;color:black">Mike<o:p></o:p></span></p>
</div>
<div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Calibri",sans-serif;color:black">----<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Calibri",sans-serif;color:black">Michael Smith<o:p></o:p></span></p>
</div>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Calibri",sans-serif;color:black">US Army Corps<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Calibri",sans-serif;color:black">Remote Sensing GIS/Center<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Calibri",sans-serif;color:black"><a href="mailto:michael.smith@usace.army.mil">michael.smith@usace.army.mil</a><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Calibri",sans-serif;color:black"><o:p> </o:p></span></p>
</div>
</div>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Calibri",sans-serif;color:black"><o:p> </o:p></span></p>
</div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">From:
</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">"Rahkonen Jukka (MML)" <<a href="mailto:jukka.rahkonen@maanmittauslaitos.fi">jukka.rahkonen@maanmittauslaitos.fi</a>><br>
<b>Date: </b>Tuesday, May 19, 2015 at 5:08 PM<br>
<b>To: </b>"Lime, Steve D (MNIT)" <<a href="mailto:Steve.Lime@state.mn.us">Steve.Lime@state.mn.us</a>>, "<a href="mailto:Steve.Toutant@inspq.qc.ca">Steve.Toutant@inspq.qc.ca</a>" <<a href="mailto:Steve.Toutant@inspq.qc.ca">Steve.Toutant@inspq.qc.ca</a>>, MapserverList
OSGEO <<a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a>><br>
<b>Cc: </b>"<a href="mailto:Michael.Smith@erdc.dren.mi">Michael.Smith@erdc.dren.mi</a>" <<a href="mailto:Michael.Smith@erdc.dren.mi">Michael.Smith@erdc.dren.mi</a>><br>
<b>Subject: </b>Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs getFeature with filter on numeric field<br>
<b>Resent-From: </b>Michael Smith <<a href="mailto:michael.smith@usace.army.mil">michael.smith@usace.army.mil</a>><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"Calibri",sans-serif;color:black"><o:p> </o:p></span></p>
</div>
<div>
<div>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Hi,</span><span lang="FI" style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FI" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><span lang="FI" style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Without being a programmer I would like to see what would happen if this source file
</span><span lang="FI" style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><span lang="FI" style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><a href="https://github.com/mapserver/mapserver/blob/branch-7-0/maporaclespatial.c">https://github.com/mapserver/mapserver/blob/branch-7-0/maporaclespatial.c</a></span><span lang="FI" style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><span lang="FI" style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">would be edited around line 571-573:</span><span lang="FI" style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">cmd = <span class="pl-pds">"</span><span class="pl-s">alter session set NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss'</span><span class="pl-pds">"</span>;</span><span lang="FI" style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"> </span><span lang="FI" style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">by adding a new block for setting the decimal and thousands separators for output</span><span lang="FI" style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"> </span><span lang="FI" style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">cmd = <span class="pl-pds">"</span><span class="pl-s">alter session set NLS_NUMERIC_CHARACTERS='. '”</span>;</span><span lang="FI" style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"> </span><span lang="FI" style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">I am not sure of the right syntax. This one works with SQL*Plus and set decimal points and space for thousands separator. I think that thousands should be without separators but the command seems to require two
inputs.</span><span lang="FI" style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"> </span><span lang="FI" style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">-Jukka Rahkonen-</span><span lang="FI" style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"> </span><span lang="FI" style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><span lang="FI" style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><span lang="FI" style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><span lang="FI" style="color:black"><o:p></o:p></span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma",sans-serif;color:black">Lähettäjä:</span></b><span style="font-size:10.0pt;font-family:"Tahoma",sans-serif;color:black">
<a href="mailto:mapserver-users-bounces@lists.osgeo.org">mapserver-users-bounces@lists.osgeo.org</a> [<a href="mailto:mapserver-users-bounces@lists.osgeo.org">mailto:mapserver-users-bounces@lists.osgeo.org</a>]
<b>Puolesta </b>Lime, Steve D (MNIT)<br>
<b>Lähetetty:</b> 19. toukokuuta 2015 22:12<br>
<b>Vastaanottaja:</b> <a href="mailto:Steve.Toutant@inspq.qc.ca">Steve.Toutant@inspq.qc.ca</a>; MapserverList OSGEO<br>
<b>Kopio:</b> <a href="mailto:Michael.Smith@erdc.dren.mi">Michael.Smith@erdc.dren.mi</a><br>
<b>Aihe:</b> Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs getFeature with filter on numeric field</span><span lang="FI" style="color:black"><o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><span style="color:black"> </span><span lang="FI" style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Is there somewhere in the capabilities response where a user would declare what decimal separators are supported?
</span><span lang="FI" style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> </span><span lang="FI" style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:black"><a href="mailto:mapserver-users-bounces@lists.osgeo.org">mapserver-users-bounces@lists.osgeo.org</a>
[<a href="mailto:mapserver-users-bounces@lists.osgeo.org">mailto:mapserver-users-bounces@lists.osgeo.org</a>]
<b>On Behalf Of </b><a href="mailto:Steve.Toutant@inspq.qc.ca">Steve.Toutant@inspq.qc.ca</a><br>
<b>Sent:</b> Tuesday, May 19, 2015 2:06 PM<br>
<b>To:</b> MapserverList OSGEO<br>
<b>Cc:</b> <a href="mailto:Michael.Smith@erdc.dren.mi">Michael.Smith@erdc.dren.mi</a><br>
<b>Subject:</b> Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs getFeature with filter on numeric field</span><span lang="FI" style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"> </span><span lang="FI" style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black">It seems to be a bug isn't?</span><span style="color:black"><br>
</span><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black">Do you want me to open an issue?</span><span lang="FI" style="color:black"><o:p></o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse">
<tbody>
<tr style="height:6.0pt">
<td width="40%" valign="top" style="width:40.0%;padding:0in 0in 0in 0in;height:6.0pt">
<p class="MsoNormal"><b><span style="font-size:7.5pt;font-family:"Arial",sans-serif">"Smith, Michael ERDC-RDE-CRREL-NH" <<a href="mailto:Michael.Smith@erdc.dren.mil">Michael.Smith@erdc.dren.mil</a>></span></b><o:p></o:p></p>
<p style="mso-line-height-alt:6.0pt"><span style="font-size:7.5pt;font-family:"Arial",sans-serif">2015-05-19 12:24</span><o:p></o:p></p>
</td>
<td width="59%" valign="top" style="width:59.0%;padding:0in 0in 0in 0in;height:6.0pt">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse">
<tbody>
<tr style="height:15.75pt">
<td width="57" valign="top" style="width:42.75pt;padding:0in 0in 0in 0in;height:15.75pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:7.5pt;font-family:"Arial",sans-serif">A</span><o:p></o:p></p>
</td>
<td valign="top" style="padding:0in 0in 0in 0in;height:15.75pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Arial",sans-serif">"<a href="mailto:Steve.Toutant@inspq.qc.ca">Steve.Toutant@inspq.qc.ca</a>" <<a href="mailto:Steve.Toutant@inspq.qc.ca">Steve.Toutant@inspq.qc.ca</a>></span><o:p></o:p></p>
</td>
</tr>
<tr style="height:15.75pt">
<td width="57" valign="top" style="width:42.75pt;padding:0in 0in 0in 0in;height:15.75pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:7.5pt;font-family:"Arial",sans-serif">cc</span><o:p></o:p></p>
</td>
<td valign="top" style="padding:0in 0in 0in 0in;height:15.75pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Arial",sans-serif">"Rahkonen Jukka (MML)" <<a href="mailto:jukka.rahkonen@maanmittauslaitos.fi">jukka.rahkonen@maanmittauslaitos.fi</a>>, MapserverList OSGEO <<a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a>></span><o:p></o:p></p>
</td>
</tr>
<tr style="height:15.75pt">
<td width="57" valign="top" style="width:42.75pt;padding:0in 0in 0in 0in;height:15.75pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:7.5pt;font-family:"Arial",sans-serif">Objet</span><o:p></o:p></p>
</td>
<td valign="top" style="padding:0in 0in 0in 0in;height:15.75pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Arial",sans-serif">Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs getFeature with filter on numeric field</span><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"> <o:p></o:p></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="393" style="width:294.75pt;border-collapse:collapse">
<tbody>
<tr style="height:6.0pt">
<td width="57" valign="top" style="width:42.75pt;padding:0in 0in 0in 0in;height:6.0pt">
</td>
<td width="336" valign="top" style="width:3.5in;padding:0in 0in 0in 0in;height:6.0pt">
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="color:black"><br>
<br>
<br>
</span><span style="font-size:10.0pt;font-family:"Calibri",sans-serif;color:black">It looks like whats happening is that’s being converted into 3 Tokens and the oracle driver converts it into a number + comma + number.
</span><span style="color:black"><br>
<br>
</span><span style="font-size:10.0pt;font-family:"Calibri",sans-serif;color:black">The tokenizer is not treating that value as a single value.
</span><span style="color:black"><br>
<br>
</span><span style="font-size:10.0pt;font-family:"Calibri",sans-serif;color:black">Mike</span><span style="color:black"><br>
<br>
</span><b><span style="font-size:10.0pt;font-family:"Calibri",sans-serif;color:black">From:
</span></b><span style="font-size:10.0pt;font-family:"Calibri",sans-serif;color:black">"</span><span style="color:black"><a href="mailto:Steve.Toutant@inspq.qc.ca"><span style="font-size:10.0pt;font-family:"Calibri",sans-serif">Steve.Toutant@inspq.qc.ca</span></a></span><span style="font-size:10.0pt;font-family:"Calibri",sans-serif;color:black">"
<</span><span style="color:black"><a href="mailto:Steve.Toutant@inspq.qc.ca"><span style="font-size:10.0pt;font-family:"Calibri",sans-serif">Steve.Toutant@inspq.qc.ca</span></a></span><span style="font-size:10.0pt;font-family:"Calibri",sans-serif;color:black">><b><br>
Date: </b>Tuesday, May 19, 2015 at 11:44 AM<b><br>
To: </b>Michael Smith <</span><span style="color:black"><a href="mailto:michael.smith@erdc.dren.mil"><span style="font-size:10.0pt;font-family:"Calibri",sans-serif">michael.smith@erdc.dren.mil</span></a></span><span style="font-size:10.0pt;font-family:"Calibri",sans-serif;color:black">><b><br>
Cc: </b>"Rahkonen Jukka (MML)" <</span><span style="color:black"><a href="mailto:jukka.rahkonen@maanmittauslaitos.fi"><span style="font-size:10.0pt;font-family:"Calibri",sans-serif">jukka.rahkonen@maanmittauslaitos.fi</span></a></span><span style="font-size:10.0pt;font-family:"Calibri",sans-serif;color:black">>,
MapserverList OSGEO <</span><span style="color:black"><a href="mailto:mapserver-users@lists.osgeo.org"><span style="font-size:10.0pt;font-family:"Calibri",sans-serif">mapserver-users@lists.osgeo.org</span></a></span><span style="font-size:10.0pt;font-family:"Calibri",sans-serif;color:black">><b><br>
Subject: </b>Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs getFeature with filter on numeric field</span><span style="color:black"><br>
<br>
</span><span style="font-family:"Calibri",sans-serif;color:#004080">here is the mapserver log with
</span><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black"><ogc:PropertyIsEqualTo matchCase="true"><ogc:PropertyName>LONG_STAT</ogc:PropertyName><ogc:Literal>-61,8031</ogc:Literal></ogc:PropertyIsEqualTo></span><span style="font-size:10.0pt;font-family:"Calibri",sans-serif;color:black"><br>
</span><span style="font-family:"Calibri",sans-serif;color:#004080"><br>
msOracleSpatialLayerWhichShapes. Using this Sql to retrieve the data: SELECT ID, NO_STAT_CLIM, NO_STAT_FADQ, NOM_STAT, LATI_STAT, LONG_STAT, ALTI_STAT, D_DEB, D_FIN, TIMB_MAJ, USAG_MAJ, rownum, GEOM_POIN FROM (select * FROM SMDVDP_STAT_METE WHERE EXTRACT(YEAR
FROM D_DEB) = 2014) WHERE ( LONG_STAT = -61.000000,8031.000000 ) AND SDO_FILTER( GEOM_POIN, MDSYS.SDO_GEOMETRY(2003, :srid, NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates ),'querytype=window') = 'TRUE'</span><span style="font-size:10.0pt;font-family:"Calibri",sans-serif;color:black"><br>
<br>
</span><span style="font-family:"Calibri",sans-serif;color:#004080"><br>
The problem is<br>
WHERE ( LONG_STAT = -61.000000,8031.000000 )</span><span style="color:black"> </span>
<span lang="FI" style="color:black"><o:p></o:p></span></p>
</div>
</div>
</div>
</body>
</html>