Hi, I'm presuming this is using the Oracle driver looking at the error message? Probably unrelated, but isn't your DATA clause missing a USING?
DATA "GEOM FROM TEST_TABLE using unique objid_parent USING SRID 25832" https://mapserver.org/input/vector/oracle.html#example-of-a-layer 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. You can also try the following syntax: DATA "GEOM FROM (SELECT * FROM TEST_TABLE) AS tbl USING UNIQUE ObjectId USING SRID=25832" Seth -- web:https://geographika.net & https://mapserverstudio.net twitter: @geographika On Wed, Jun 26, 2024, at 12:16 PM, G. Völkl via MapServer-users wrote: > Hello > >> In the map file is this statement >> >> DATA "GEOM FROM TEST_TABLE using unique objid_parent SRID 25832" >> >> I get this message from mapserver in log file >> >> >> Error: ORA-00907: missing right parentesis >> . Query statement: SELECT SDO_AGGR_MBR(GEOM) AS GEOM from (SELECTGEOM FROM >> test_table) >> >> This have to be changed SELECTGEOM to select geom >> >> Can I do something in the map file or is it a bug? > > Best regards Gerhard >> > Von meinem iPhone gesendet > _______________________________________________ > MapServer-users mailing list > [email protected] > https://lists.osgeo.org/mailman/listinfo/mapserver-users >
_______________________________________________ MapServer-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/mapserver-users
