[mapserver-users] OCI-22053: overflow error with CONNECTIONTYPEoraclespatial

[Nolte, Tim]

Stefan,

Do you have the Georaptor extension installed in SQL Dev? Have you tried to run the verification on all of the geom data in that table?

- Tim

----
Timothy J Nolte - tnolte at ilpcs.com
Network Planning Engineer

4717 Broadmoor Ave, Suite G
Kentwood, MI 49512

Office:  616-656-5163
PCS:     616-706-2438
Support: 616-929-0289
Fax:     616-554-6484


-----Original Message-----
From: mapserver-users-bounces at lists.osgeo.org [mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of Stefan Schantz
Sent: Wednesday, February 03, 2010 7:55 AM
To: mapserver-users at lists.osgeo.org
Subject: [mapserver-users] OCI-22053: overflow error with CONNECTIONTYPEoraclespatial

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
mapserver-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users