[MapServer-users] Error in msplugin_oracle.dll / maporaclespatial.c

[Kulawik, Robert]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20240723/fa9d55ce/attachment.htm>