Zach, Your DATA statement is almost correct. If you are going to use the UNIQUE keyword (for supporting queries), you must put a column name after UNIQUE and before the SRID.
Either of these would work: DATA ' GEOM from STATES using UNIQUE ID srid 90112' or DATA ' GEOM from STATES using srid 90112' Assuming you have a column named ID, of course. Mike -- Michael Smith RSGIS Center ERDC - CRREL US Army Corps of Engineers On 11/17/08 8:21 PM, "zach cruise" <[EMAIL PROTECTED]> wrote: > troubleshooting info on 4.8 box with /ignored-libmap/oracle10g/libmap.dll: > shp2img -m oracle.map -o oracle.png -all_debug 10 > msOracleSpatialLayerOpen called with: GEOMETRY from STATES using > unique srid 90112 > msOracleSpatialLayerOpen. Shared connection not available. Creating one. > msConnPoolRegister(layername,username/[EMAIL PROTECTED],019A68E8) > msOracleSpatialLayerFreeItemInfo was called. > msOracleSpatialLayerWhichShapes was called. > msOracleSpatialLayerWhichShapes(): OracleSpatial error. Error parsing > OracleSpatial DATA variable. Must be:'geometry_column FROM table_name > [USING UNIQUE <column> SRID srid# FUNCTION]' or 'geometry_column FROM > (SELECT stmt) [USING UNIQUE <column> SRID srid# FUNCTION]'. If want to > set the FUNCTION statement you can use: FILTER, RELATE, GEOMRELATE or > NONE. Your data statement: GEOM from STATES using unique srid 90112 > > On Mon, Nov 17, 2008 at 7:34 PM, zach cruise <[EMAIL PROTECTED]> wrote: >> btw i got oracle 10 client (with tnsnames.ora) on 4.8 box. other than >> returning multiple ora-xxxx errors, 4.8 also returns "web template >> error" if i use /ignored-libmap/oracle10g/libmap.dll. this error is >> even for only shapefile maps. error goes away when i switch back to >> normal libmap.dll. >> >> On Mon, Nov 17, 2008 at 5:56 PM, zach cruise <[EMAIL PROTECTED]> wrote: >>> looks like mod_fastcgi is not an option with ms4w and oracle 10. >>> anyway it had little benefits. >>> >>> i now got mapserver 5.2 and 4.8: >>> i thought 5.2 had native built-in support for oracle 10, but it is >>> giving me "OracleSpatial is not supported" error. i also thought 4.8 >>> could get ogr support for oracle 10 by following the steps on >>> http://www.maptools.org/ms4w/index.phtml?page=README_INSTALL.html#oracle-10g>>> . >>> 4.8 connects, but returns multiple ORA-xxxx errors. >>> >>> so: >>> do i have to install oracle 10 client locally and make changes to >>> httpd.conf for 5.2 to work? >>> how do i find correct srid for 4.8 to work? (DATA "GEOMETRY from >>> (select GEOMETRY from STATES where NAME = 'New York')") >>> any performance difference between native built-in and ogr supports? >>> >>> On Fri, Nov 14, 2008 at 6:22 PM, Jeff McKenna >>> <[EMAIL PROTECTED]> wrote: >>>> zach cruise wrote: >>>>> >>>>> does current ms4w with fastcgi work with oracle 10? >>>>> >>>>> here're warnings >>>>> http://www.maptools.org/ms4w/?page=README_INSTALL.html#f-fastcgi >>>>> >>>>> http://www.nabble.com/fastcgi-connections-to-Oracle-and-SDE-on-Windows-to1 >>>>> 8394152.html >>>>> in testing this was successful with PostgreSQL 8.3.1 / PostGIS 1.3.3, >>>>> but unsuccessful with Oracle 10.2.0.1.0 (Apache logs: "mod_fcgid: get >>>>> overlap result error") >>>>> >>>>> if not, any workarounds? >>>> >>>> I tested and wrote that note...and am not aware of a workaround yet. You >>>> should also send this question to the MS4W mailing list (subscribe at: >>>> http://lists.maptools.org/mailman/listinfo/ms4w-users) >>>> >>>> >>>> -- >>>> Jeff McKenna >>>> FOSS4G Consulting and Training Services >>>> http://www.gatewaygeomatics.com/ >>>> >>>> >>>> _______________________________________________ >>>> mapserver-users mailing list >>>> mapserver-users@lists.osgeo.org >>>> http://lists.osgeo.org/mailman/listinfo/mapserver-users >>>> >>> >> > _______________________________________________ > mapserver-users mailing list > mapserver-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapserver-users _______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users