[MapServer-users] Missing blank in SQL

[Seth G]

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
> MapServer-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapserver-users
> 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20240626/ae994d4e/attachment.htm>