using oraclespatial data in map

[Oliver Wesp]

Try changing your data statement to

DATA "SHAPE FROM ESRI.COUNTRY_TSQA USING SRID xxxxx"

Change xxxxx to whatever SRID your spatial table has. You can lookup the 
SRID in MDSYS.ALL_SDO_GEOM_METADATA

Oliver

John Cartwright schrieb:

> Hello All,
>
> I'm trying to use oracle spatial table (geographic WGS84 coords)  as a 
> layer in a map and seem to be having trouble w/ the projection.  The 
> layer is defined as:
>    LAYER
>        NAME admin2
>        CONNECTIONTYPE oraclespatial
>        CONNECTION "dbuser/dbpass at oraclehost"
>        DATA "SHAPE FROM ESRI.COUNTRY_TSQA"
>        STATUS off
>        TYPE polygon
>
>         CLASS
>                OUTLINECOLOR 0 0 255
>         END
>        PROJECTION
>           "init=epsg:4326"
>        END
>    END
>
>
> However, mapserver seems to be generating an SQL query w/ a NULL SRID:
>
> ORA-13208: internal error  while evaluating [window SRID does not 
> match layer SRID] operator
> ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 281
> ORA-06512: at line 1
> . Query statement: SELECT rownum, SHAPE FROM ESRI.COUNTRY_TSQA WHERE 
> SDO_FILTER( SHAPE, MDSYS.SDO_GEOMETRY(2003, NULL, 
> NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-179.75,-89.875,179.75,89.875) 
> ),'querytype=window') = 'TRUE' . Check your data 
> statement.
>
>
> Can anyone help me with the proper mapfile syntax?
>
> Thanks!
>
> -- john
>
>
>


-- 
Dipl.-Geogr. Oliver Wesp
Gesellschaft fuer geografische Datenverarbeitung
Binger Strasse 49-51
D-55218 Ingelheim
fon: +49 6132 714818
fax: +49 6132 714828
http: www.gdv.com