OracleSpatial getFeatureInfo problem against unique column containing text

[Bart van den Eijnden (OSGIS)]

No this is not possible.

You need to use an integer for the unique column. It's a requirement.

Best regards,
Bart

--
Bart van den Eijnden
OSGIS, Open Source GIS
http://www.osgis.nl


--------- Oorspronkelijk bericht --------
Van: Sebastian Schmitz <sebastian.schmitz at WHEREGROUP.COM>
Naar: MAPSERVER-USERS at LISTS.UMN.EDU <MAPSERVER-USERS at LISTS.UMN.EDU>
Onderwerp: [UMN_MAPSERVER-USERS] OracleSpatial getFeatureInfo problem
against unique column containing text
Datum: 23/02/07 08:33

> 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 &quot;GDI/****@ORCL_HOGGNO&quot;
>   #not serving getFeatureInfo
>   DATA &quot;GEOM FROM V_*** USING UNIQUE SST_NR SRID 8307 FILTER VERSION
10g&quot;
>   #serving getFeatureInfo
>   DATA &quot;GEOM FROM V_*** USING UNIQUE substr(SST_NR,3,7) SRID 8307
FILTER 
> VERSION 10g&quot;
>   FILTER &quot;BEREICHKZ = '3'&quot;
> ...
> 
> 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 &amp; 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
> ---------------------------------------
> 
>