WFS and Oracle

[Huub Fleuren]

Hello,

If you use Mapserver 4.6 and later for wfs requests on Oracle Spatal layers do not use the 'normal' synstax of 

DATA "GEOMETRIE FROM GEBOUW USING UNIQUE ID SRID 90112"

This helps Mapserver very much to crash

Instead use the other syntax that works for joins as the datasource 
DATA "GEOMETRIE FROM (SELECT GEOMETRIE, ID FROM GEBOUW ) USING UNIQUE ID SRID 90112"

This has been tested on database versions 10g and 9.2

I suppose the suggestion to compile on windows with MSVC service pack 4 5 or 6 holds, i didn't go back on that.

Regards,
Huub