[Date Prev][Date Next]
[Chronological]
[Thread]
[Top]
[Mapserver-users] Oraclespatial ORA-01405 msOracleSpatialLayerWhichShapes
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@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@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@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