Hi Tim,
with Georaptor I could draw all the point from the table without any
error messages. But if I use the geom-validator, I get an error
"ORA-13000: dimension number is out of range". After I corrected the
dimension number, the error message from the UMN disappeared.
Thank you!
Stefan
Nolte, Tim schrieb:
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
