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 - [email protected] 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: [email protected] [mailto:[email protected]] On Behalf Of Stefan Schantz Sent: Wednesday, February 03, 2010 7:55 AM To: [email protected] 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 [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
