<!DOCTYPE html><html><head><title></title><style type="text/css">p.MsoNormal,p.MsoNoSpacing{margin:0}</style></head><body><div>Hi,<br></div><div><br></div><div>I'm presuming this is using the Oracle driver looking at the error message? <br></div><div>Probably unrelated, but isn't your DATA clause missing a USING?<br></div><div><br></div><div>DATA "GEOM FROM TEST_TABLE using unique objid_parent USING SRID 25832"<br></div><div><br></div><div><a href="https://mapserver.org/input/vector/oracle.html#example-of-a-layer">https://mapserver.org/input/vector/oracle.html#example-of-a-layer</a><br></div><div><br></div><div>I remember the DATA clause when logged was missing spaces in the MSSQL driver, but the actual SQL sent to the database was fine - you can check this with a SQL profiler.<br></div><div><br></div><div>You can also try the following syntax:<br></div><div><br></div><div>DATA "GEOM FROM (SELECT * FROM TEST_TABLE) AS tbl USING UNIQUE ObjectId USING SRID=25832"<br></div><div><br></div><div>Seth<br></div><div><br></div><div id="sig62266145"><div class="signature">--<br></div><div class="signature">web:<a href="https://geographika.net">https://geographika.net</a> & <a href="https://mapserverstudio.net">https://mapserverstudio.net</a><br></div><div class="signature">twitter: @geographika<br></div></div><div><br></div><div>On Wed, Jun 26, 2024, at 12:16 PM, G. Völkl via MapServer-users wrote:<br></div><blockquote type="cite" id="qt" style=""><div>Hello<br></div><div><br></div><div><blockquote type="cite" style="color:rgb(0, 0, 0);"><div dir="ltr"><div class="qt-WordSection1" style=""><p class="qt-MsoNormal" style="margin-top:0cm;margin-right:0cm;margin-bottom:0.0001pt;margin-left:0cm;font-size:11pt;font-family:Arial, sans-serif;">In the map file is this statement<br></p><p class="qt-MsoNormal" style="margin-top:0cm;margin-right:0cm;margin-bottom:0.0001pt;margin-left:0cm;font-size:11pt;font-family:Arial, sans-serif;"> <br></p><p class="qt-MsoNormal" style="margin-top:0cm;margin-right:0cm;margin-bottom:0.0001pt;margin-left:0cm;font-size:11pt;font-family:Arial, sans-serif;line-height:14.25pt;background-color:rgb(31, 31, 31);background-position-x:0%;background-position-y:0%;background-repeat:repeat;background-attachment:scroll;background-image:none;background-size:auto;background-origin:padding-box;background-clip:border-box;"><span style="color:rgb(86, 156, 214);"><span class="font" style="font-family:Consolas;"><span class="size" style="font-size:10.5pt;">DATA</span></span></span><span style="color:rgb(204, 204, 204);"><span class="font" style="font-family:Consolas;"><span class="size" style="font-size:10.5pt;"> "GEOM FROM TEST_TABLE using unique objid_parent SRID 25832"</span></span></span><br></p><p class="qt-MsoNormal" style="margin-top:0cm;margin-right:0cm;margin-bottom:0.0001pt;margin-left:0cm;font-size:11pt;font-family:Arial, sans-serif;"> <br></p><p class="qt-MsoNormal" style="margin-top:0cm;margin-right:0cm;margin-bottom:0.0001pt;margin-left:0cm;font-size:11pt;font-family:Arial, sans-serif;">I get this message from mapserver in log file<br></p><p class="qt-MsoNormal" style="margin-top:0cm;margin-right:0cm;margin-bottom:0.0001pt;margin-left:0cm;font-size:11pt;font-family:Arial, sans-serif;"> <br></p><p class="qt-MsoNormal" style="margin-top:0cm;margin-right:0cm;margin-bottom:0.0001pt;margin-left:0cm;font-size:11pt;font-family:Arial, sans-serif;"> <br></p><p class="qt-MsoNormal" style="margin-top:0cm;margin-right:0cm;margin-bottom:0.0001pt;margin-left:0cm;font-size:11pt;font-family:Arial, sans-serif;">Error: ORA-00907: missing right parentesis<br></p><p class="qt-MsoNormal" style="margin-top:0cm;margin-right:0cm;margin-bottom:0.0001pt;margin-left:0cm;font-size:11pt;font-family:Arial, sans-serif;">. Query statement: SELECT SDO_AGGR_MBR(GEOM) AS GEOM from (SELECTGEOM FROM test_table)<br></p><p class="qt-MsoNormal" style="margin-top:0cm;margin-right:0cm;margin-bottom:0.0001pt;margin-left:0cm;font-size:11pt;font-family:Arial, sans-serif;"> <br></p><p class="qt-MsoNormal" style="margin-top:0cm;margin-right:0cm;margin-bottom:0.0001pt;margin-left:0cm;font-size:11pt;font-family:Arial, sans-serif;">This have to be changed SELECTGEOM to select geom<br></p><p class="qt-MsoNormal" style="margin-top:0cm;margin-right:0cm;margin-bottom:0.0001pt;margin-left:0cm;font-size:11pt;font-family:Arial, sans-serif;"> <br></p><p class="qt-MsoNormal" style="margin-top:0cm;margin-right:0cm;margin-bottom:0.0001pt;margin-left:0cm;font-size:11pt;font-family:Arial, sans-serif;">Can I do something in the map file or is it a bug?<br></p></div></div></blockquote><div><br></div><div>Best regards Gerhard <br></div><blockquote type="cite" style="color:rgb(0, 0, 0);"><div dir="ltr"><div class="qt-WordSection1" style=""><p class="qt-MsoNormal" style="margin-top:0cm;margin-right:0cm;margin-bottom:0.0001pt;margin-left:0cm;font-size:11pt;font-family:Arial, sans-serif;"><br></p></div></div></blockquote><div dir="ltr">Von meinem iPhone gesendet<br></div></div><div>_______________________________________________<br></div><div>MapServer-users mailing list<br></div><div><a href="mailto:MapServer-users@lists.osgeo.org">MapServer-users@lists.osgeo.org</a><br></div><div><a href="https://lists.osgeo.org/mailman/listinfo/mapserver-users">https://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br></div><div><br></div></blockquote><div><br></div></body></html>