[Mapserver-users] Oraclespatial ORA-01405 msOracleSpatialLayerWhichShapes

[FERNANDO SIMON]

Hi Vladimir,
   I believe that I can help you, but I need to do some questions. Well, how you
define your layer in the mapfile? What do you want to draw? Lines,polygons,
points? Do you need to use the "value" column? Expression? Filter? Label?
   This error, is a Oracle error, sql error. The maporaclespatiel reported you
with one Oracle error. If you try to execute the same query (SELECT ORA GEOM,
VALUE, NAME FROM EXAMPLE_TABLE) in the sqlplus. What's happen? Some error?
   I don't know if I solve your problem. If you need more help I can help you.

==================================================================
Fernando Simon - simon at cttmar.univali.br
DataBase Manager, Mapserver and MapOracleSpatial Developer
G10 - Laboratório de Computação Aplicada
http://g10.cttmar.univali.br
==================================================================


Quoting Vladimir Guzmán <bigfoot at main-task.com>:

> 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 
> 
> _______________________________________________
> Mapserver-users mailing list
> Mapserver-users at lists.gis.umn.edu
> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
> 




------------------------------------------------
Este e-mail foi enviado pelo webmail do curso de
       Ciência da Computação - UNIVALI