OracleSpatial getFeatureInfo problem against unique column containing text
Sebastian Schmitz
sebastian.schmitz at WHEREGROUP.COM
Fri Feb 23 02:27:41 PST 2007
Hi,
I have a view in Oracle Spatial 10gR2 with a unique Id, which is text.
MapServer draws the map OK using oraclespatial CONNECTIONTYPE.
However, MapServer is unable to serve a getFeatureInfo request against
that view. If I change the DATA statement to substr(ID, 3,7), removing
letters from the ID - getFeatureInfo runs fine for the time being, but
without the letters my ID will soon lose its uniqueness.
Is MapServer able to server a getFeatureInfo request against DATA that
uses a unique text-column containing letters?
Find more detail below:
mapfile:
...
CONNECTIONTYPE oraclespatial
CONNECTION "GDI/****@ORCL_HOGGNO"
#not serving getFeatureInfo
DATA "GEOM FROM V_*** USING UNIQUE SST_NR SRID 8307 FILTER VERSION 10g"
#serving getFeatureInfo
DATA "GEOM FROM V_*** USING UNIQUE substr(SST_NR,3,7) SRID 8307 FILTER
VERSION 10g"
FILTER "BEREICHKZ = '3'"
...
log:
Fri Feb 23 10:54:40 2007 - msOracleSpatialLayerGetShape(): OracleSpatial
error. Error: ORA-01722: invalid number
. Query statement: SELECT ***,***, GEOM FROM V_*** WHERE SST_NR = 0 AND
BEREICHKZ = '2' .Check your data statement.
SST_NR in this case should not be null, but sth. like 'SS0023093 '.
Cheers
Sebastian
--
---------------------------------------
WhereGroup GmbH & Co. KG
Siemensstraße 8
53121 Bonn
-------------------------------
Fon: +49 (0)228 / 90 90 38 - 24
Fax: +49 (0)228 / 90 90 38 - 11
-------------------------------
mailto:sebastian.schmitz at wheregroup.com
http://www.wheregroup.com
-------------------------------
Komplementärin:
WhereGroup Verwaltungs GmbH
vertreten durch:
Arnulf Christl, Olaf Knopp, Peter Stamm
Amtsgericht Bonn, HRB 9885
---------------------------------------
More information about the MapServer-users
mailing list