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' And put in the minx,miny,maxx, maxy values from the debug log to verify its all working properly. From: Michele De Santis <[email protected]<mailto:[email protected]>> Reply-To: Michele De Santis <[email protected]<mailto:[email protected]>> Date: Mon, 20 Aug 2012 18:00:53 +0200 To: Michael Smith <[email protected]<mailto:[email protected]>>, "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> Subject: R: Re: [mapserver-users] oraclespatial connection Thank you Michael, I tried without version but with the same result. Michele ----Messaggio originale---- Da: [email protected]<mailto:[email protected]> Data: 20-ago-2012 17.53 A: "Michele De Santis"<[email protected]<mailto:[email protected]>>, "[email protected]<mailto:[email protected]>"<[email protected]<mailto:[email protected]>> Ogg: Re: [mapserver-users] oraclespatial connection Michele, Try with DATA "SHAPE FROM PSITDATA.COMUNI USING SRID 32633" The VERSION 10g part doesn't need to be used anymore. Mike -- Michael Smith Remote Sensing/GIS Center US Army Corps of Engineers From: Michele De Santis <[email protected]<mailto:[email protected]>> Reply-To: Michele De Santis <[email protected]<mailto:[email protected]>> Date: Mon, 20 Aug 2012 17:37:33 +0200 To: <[email protected]<mailto:[email protected]>> Subject: [mapserver-users] oraclespatial connection Resent-From: Michael Smith <[email protected]<mailto:[email protected]>> Hi, I'm using MS4W with connection to Oraclespatial. I followed the istructions on http://www.maptools.org/ms4w/index.phtml?page=README_INSTALL.html#oracle-10g-11g to enable Oracle 10g support and "mapserv -v" returns a string that contains "INPUT=ORACLESPATIAL" In mapfile I have a Layer: LAYER NAME PSITDATA.COMUNI TYPE POLYGON CONNECTIONTYPE oraclespatial CONNECTION "UN/PW@DBSVILPU" DATA "SHAPE FROM PSITDATA.COMUNI USING SRID 32633 VERSION 10g" CLASS STYLE OUTLINECOLOR 0 0 0 COLOR 0 128 128 END END METADATA "wms_title" "PSITDATA.COMUNI" #"wms_srs" "EPSG:26591" "wms_srs" "EPSG:32633" "wms_name" "PSITDATA.COMUNI" "wms_server_version" "1.1.1" "wms_format" "image/png" "wms_enable_request" "*" ##necessary END PROJECTION "init=epsg:32633" END END but I have the error: ORA-06553: PLS-306: wrong number or types of arguments in call to 'SDO_FILTER' . Query statement: 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),:ordinates ),'querytype=window') = 'TRUE' . Check your data statement. When I tried the SELECT in SQL*PLUS I had obtained: SP2-0552: Bind variable "ORDINATES" not declared Can you help me with the this error and with mapfile syntax? Thank you Michele _______________________________________________ mapserver-users mailing list [email protected]<mailto:[email protected]>http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
