[mapserver-users] OCI-22053: overflow error with CONNECTIONTYPE oraclespatial

[Stefan Schantz]

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