Hello,
I am trying to visualize some points from a oracle database (10.2) :
I am using
MapServer version 5.2.0 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP
OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=AGG SUPPORTS=FREETYPE SUPPORTS=ICONV
SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER
SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER SUPPORTS=GEOS INPUT=EPPL7
INPUT=POSTGIS INPUT=ORACLESPATIAL INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE
My layer description is
----
LAYER
NAME "tra_punkte"
TYPE POINT
STATUS ON
DEBUG ON
#DUMP TRUE
CONNECTIONTYPE oraclespatial
CONNECTION
"***/***@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=***)(PORT=
1521)))(CONNECT_DATA=(SID=***)))"
DATA "GEOM
from
(select geom, HOEHE, AUSGANGSHOEHE, ID
FROM imis_geo.trapkt_6222
)
USING UNIQUE ID SRID 4326"
-------
and the following statement is written in the log-file
------
[Wed Feb 3 12:54:00 2010].603594 msOracleSpatialLayerWhichShapes. Using
this Sql to retrieve the data: SELECT ID, GEOM FROM (select geom, HOEHE,
AUSGANGSHOEHE, ID
FROM imis_geo.trapkt_6222
) WHERE SDO_FILTER( GEOM, MDSYS.SDO_GEOMETRY(2003, 4326,
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-70.5721827,29.3243683,69.9787827,79.1709317)
),'querytype=window') = 'TRUE'
[Wed Feb 3 12:54:00 2010].823525 osGetOrdinates(): OracleSpatial error.
OCI-22053: overflow error
------
But if I try the sql in SQL-Developer, i get the result without any errors?
The connection between UMN and oracle database is working fine in
several different layers, but not in this one. Is there anything I can do?
Best Regards,
Stefan
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
