Hi, as answer to Seth G and Sven S fron other reply:
the suggestion to use that Statment : DATA "GEOM FROM (SELECT * FROM TEST_TABLE) AS tbl USING UNIQUE ObjectId USING SRID=25832" is not working, "(SELECT * FROM TEST_TABLE) AS tbl" and/or "SRID=25832" both produce this error: Error parsing OracleSpatial DATA variable. Must be: 'geometry_column FROM table_name [USING UNIQUE <column> SRID srid# FUNCTION]' or 'geometry_column FROM (SELECT stmt) [USING UNIQUE <column> SRID srid# FUNCTION]'. If want to set the FUNCTION statement you can use: FILTER, RELATE, GEOMRELATE or NONE. the space is simply missing in Mapserver request SELECTGEOMETRIE "osAggrGetExtent was called: SELECT SDO_AGGR_MBR(GEOMETRIE) AS GEOM from (SELECTGEOMETRIE FROM (select OID, KLASSE, GEOMETRIE from MYTABLE))" Statement Does somebody has any idea? Best regards / viele Grüße Robert Kulawik -----Ursprüngliche Nachricht----- Von: MapServer-users <[email protected]> Im Auftrag von Kulawik, Robert via MapServer-users Gesendet: Dienstag, 23. Juli 2024 10:48 An: [email protected] Betreff: [MapServer-users] Error in msplugin_oracle.dll / maporaclespatial.c Hello Mapserver community, I've been getting an error since Mapserserver 8.X with Oracle Spatial 19c request using the function "osAggrGetExtent" when I reference a database table: [Mon Jul 22 18:42:36 2024].226000 osAggrGetExtent was called: SELECT SDO_AGGR_MBR(GEOMETRIE) AS GEOM from (SELECTGEOMETRIE FROM (select OID, KLASSE, GEOMETRIE from MYTABLE)). There is no space inserted between SELECT and GEOMETRIE (see SELECTGEOMETRIE FROM.) this produces an error: [Mon Jul 22 18:42:36 2024].227000 Error: ORA-00907: Rechte Klammer fehlt (Right bracket missing) . Query statement: SELECT SDO_AGGR_MBR(GEOMETRIE) AS GEOM from (SELECTGEOMETRIE FROM (select OID, KLASSE, GEOMETRIE from MYTABLE)) .Check your data statement.in msOracleSpatialLayerGetExtent() [Mon Jul 22 18:42:36 2024].227000 msOracleSpatialLayerGetExtent(): OracleSpatial error. Check your data statement and server logs The result is that the layer is not loaded. My request in the mapfile ist: DATA 'GEOMETRIE from (select OID, KLASSE, GEOMETRIE from MYTABLE) USING UNIQUE OID SRID 25832' the connection uses the oci plugin "msplugin_oracle.dll" I use the mapserver 8.2.0 with GDAL 3.9.1 from gisinternals.com for now under Win Server 2019 https://gisinternals.com/query.html?content=filelist&file=release-1930-x64-gdal-3-9-1-mapserver-8-2-0.zip does anyone have a solution for this problem? thanks in advance Best regards / viele Grüße Robert Kulawik _______________________________________________ MapServer-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/mapserver-users
