ORACLE / Using unique

[Fernando Simon]

Hi François,
    You can do this with the to_number in you sql, like:
        data "geom FROM (SELECT TO_NUMBER(<idcolumn>) AS id FROM 
<table>) USING UNIQUE id"
    To use this way the idcolumn must need to store only numbers.
    Best regards.

------------------------------------------------------------------------
Fernando Simon
Mapserver and Oracle Spatial developer
G10 - Laboratorio de Computacao Aplicada - Brazil
http://www.univali.br/g10 - UNIVALI/CTTMAR
------------------------------------------------------------------------


François Prunayre wrote:

>Hello, when using UNIQUE with an Oracle Spatial Layer we have to "must pass
>a numeric column type" ... 
>When we have a table with a primary key type VARCHAR ... Is there any way to
>use UNIQUE without changing the data model ? ROWID is not numeric, ROWNUM is
>numeric but it's not an identifier ... So should not work.
>
>Any ideas ?
>Thanks. Francois
>
>
>  
>