thanks mike, but i get the same ora-xxxxx errors when using either: shp2img -m oracle.map -o oracle.png -all_debug 10 msOracleSpatialLayerOpen called with: GEOM from STATES using unique ID srid 90112 msOracleSpatialLayerOpen. Shared connection not available. Creating one. msConnPoolRegister(layername,username/[EMAIL PROTECTED],019A68E8) msOracleSpatialLayerFreeItemInfo was called. msOracleSpatialLayerWhichShapes was called. msOracleSpatialLayerWhichShapes. Using this Sql to retrieve the data: SELECT ID, GEOM FROM STATES WHERE SDO_FILTER( GEOM, MDSYS.SDO_GEOM(2003, 90112, NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-179,-89.5166667,179,83.5166667) ),'querytype=window') = 'TRUE' msOracleSpatialLayerWhichShapes(): OracleSpatial error. Error: ORA-29900: operator binding does not exist ORA-06540: PL/SQL: compilation error ORA-06553: PLS-907: cannot load library unit MDSYS.SDO_3GL (referenced by MDSYS.SDO_FILTER) . Query statement: SELECT ID, GEOM FROM STATES WHERE SDO_FILTER( GEOM, MDSYS.SDO_GEOM(2003, 90112, NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO _ORDINATE_ARRAY(-179,-89.5166667,179,83.5166667) ),'querytype=window') = 'TRUE' . Check your data statement.
using 4.8 with /ignored-libmap/oracle10g/libmap.dll. how do i tell if i have native or ogr support for oracle 10g? i also edited httpd.conf (did i need to?) from http://mapserver.gis.umn.edu/docs/howto/oracle_spatial_howto, but still no luck. On Tue, Nov 18, 2008 at 6:42 AM, Smith, Michael ERDC-CRREL-NH <[EMAIL PROTECTED]> wrote: > 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
