[mapserver-users] R: Re: oraclespatial connection

2012-08-20 Thread Michele De Santis
Thank you Michael, I tried without version but with the same result. Michele Messaggio originale Da: michael.sm...@erdc.dren.mil Data: 20-ago-2012 17.53 A: Michele De Santistap...@virgilio.it, mapserver-users@lists.osgeo.orgmapserver-users@lists.osgeo.org Ogg: Re:

Re: [mapserver-users] R: Re: oraclespatial connection

2012-08-20 Thread Smith, Michael ERDC-RDE-CRREL-NH
Hmm, You can't use that statement directly in sqlplus You could use SELECT OBJECTID_1,rownum, SHAPE FROM PSITDATA.COMUNI WHERE SDO_FILTER( SHAPE, MDSYS.SDO_GEOMETRY(2003, :srid, NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),sdo_ordinate_array(minx, miny, maxx, maxy) ),'querytype=window') = 'TRUE'

Re: [mapserver-users] R: Re: oraclespatial connection

2012-08-20 Thread Jeff McKenna
Hello, I have an old local 10g instance that I use for testing. My LAYER contains: CONNECTIONTYPE oraclespatial CONNECTION jeff/marvin@geo DATA ORA_GEOMETRY FROM (SELECT ORA_GEOMETRY FROM PARK) I often do testing for layers through OGR first, using the ogrinfo commandline utility,