[Mapserver-users] Oraclespatial ORA-01405 msOracleSpatialLayerWhichShapes

[Vladimir Guzmán]

Hello, everybody.

I have a layer in oraclespatial and I need to get some values to make a 
classification.
It is something like this:

DATA="ORA_GEOM FROM (SELECT ORA GEOM, VALUE, NAME FROM EXAMPLE_TABLE)"

The problem is: if the column "VALUE" has null values, mapserver dies with:

[MapServer Error]: msOracleSpatialLayerWhichShapes(): ORA-01405: fetched 
column value is NULL

If I try the same query with OGR there is no problem.

I could restrict the query with something like:

DATA="ORA_GEOM FROM (SELECT ORA GEOM, VALUE, NAME FROM EXAMPLE_TABLE 
WHERE VALUE IS NOT NULL)"

But anyway I need the geometries drawn even if these have no value.

Is this a feature or a bug?

Thanks a lot,

-- 
Vladimir Ilich Guzmán R.
------------------------
http://maintask.com