sql*plus returns this error: ORA-06553: PLS-221: 'SDO_GEOM' is not a procedure or is undefined 06553. 00000 - "PLS-%s: %s" *Cause: *Action: Error at Line:x Column:x
"select ID, GEOM from STATES" works though. i have oracle locator not spatial, if that matters. also column GEOM is type SDO_GEOMETRY with MDSYS.SPATIAL_INDEX. On Tue, Nov 18, 2008 at 12:49 PM, Rahkonen Jukka <[EMAIL PROTECTED]> wrote: > Hi, > > Have you checked that the SQL 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' > > works from SQL*Plus or something else that you are using with your Oracle? If > not, then investigate and adjust the DATA string accordingly. > > -Jukka Rahkonen- > > > > > > -----Alkuperäinen viesti----- > Lähettäjä: [EMAIL PROTECTED] puolesta: zach cruise > Lähetetty: ti 18.11.2008 19:44 > Vastaanottaja: mapserver-users@lists.osgeo.org > Kopio: Richard Polk; Smith,Michael ERDC-CRREL-NH > Aihe: Re: [mapserver-users] ms4w (fastcgi) and oracle 10? > > 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 > >
_______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users