<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; color: rgb(0, 0, 0); font-size: 14px; font-family: Calibri, sans-serif; ">
<div>Hmm,</div>
<div><br>
</div>
<div>You can't use that statement directly in sqlplus</div>
<div><br>
</div>
<div>You could use</div>
<div><br>
</div>
<div>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' </div>
<div><br>
</div>
<div>And put in the minx,miny,maxx, maxy values from the debug log to verify its all working properly. </div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<span id="OLK_SRC_BODY_SECTION">
<div style="font-family:Calibri; font-size:11pt; text-align:left; color:black; BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt">
<span style="font-weight:bold">From: </span>Michele De Santis <<a href="mailto:tape2m@virgilio.it">tape2m@virgilio.it</a>><br>
<span style="font-weight:bold">Reply-To: </span>Michele De Santis <<a href="mailto:tape2m@virgilio.it">tape2m@virgilio.it</a>><br>
<span style="font-weight:bold">Date: </span>Mon, 20 Aug 2012 18:00:53 +0200<br>
<span style="font-weight:bold">To: </span>Michael Smith <<a href="mailto:michael.smith@erdc.dren.mil">michael.smith@erdc.dren.mil</a>>, "<a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a>" <<a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a>><br>
<span style="font-weight:bold">Subject: </span>R: Re: [mapserver-users] oraclespatial connection<br>
</div>
<div><br>
</div>
Thank you Michael,<br>
<br>
I tried without version but with the same result.<br>
<br>
Michele<br>
<br>
<br>
----Messaggio originale----<br>
Da: <a href="mailto:Michael.Smith@erdc.dren.mil">Michael.Smith@erdc.dren.mil</a><br>
Data: 20-ago-2012 17.53<br>
A: "Michele De Santis"<<a href="mailto:tape2m@virgilio.it">tape2m@virgilio.it</a>>, "<a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a>"<<a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a>><br>
Ogg: Re: [mapserver-users] oraclespatial connection<br>
<br>
<!--
-->
<div>Michele,</div>
<div><br>
</div>
<div>Try with </div>
<div><br>
</div>
<div> DATA "SHAPE FROM PSITDATA.COMUNI USING SRID 32633" </div>
<div><br>
</div>
<div>The VERSION 10g part doesn't need to be used anymore.</div>
<div><br>
</div>
<div>Mike</div>
<div><br>
</div>
<div>
<div>
<div>
<div>-- </div>
<div>Michael Smith</div>
</div>
<div>Remote Sensing/GIS Center</div>
<div>US Army Corps of Engineers</div>
</div>
</div>
<div><br>
</div>
<span id="OLK_SRC_BODY_SECTION">
<div style="font-family:Calibri; font-size:11pt; text-align:left; color:black; BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt">
<span style="font-weight:bold">From: </span>Michele De Santis <<a href="mailto:tape2m@virgilio.it">tape2m@virgilio.it</a>><br>
<span style="font-weight:bold">Reply-To: </span>Michele De Santis <<a href="mailto:tape2m@virgilio.it">tape2m@virgilio.it</a>><br>
<span style="font-weight:bold">Date: </span>Mon, 20 Aug 2012 17:37:33 +0200<br>
<span style="font-weight:bold">To: </span><<a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a>><br>
<span style="font-weight:bold">Subject: </span>[mapserver-users] oraclespatial connection<br>
<span style="font-weight:bold">Resent-From: </span>Michael Smith <<a href="mailto:michael.smith@usace.army.mil">michael.smith@usace.army.mil</a>><br>
</div>
<div><br>
</div>
<span>Hi, </span><br>
<br>
<span>I'm using MS4W with connection to <span class="bold highlight search-highlight">
Oraclespatial</span>. I followed the istructions on </span><br>
<br>
<a href="http://www.maptools.org/ms4w/index.phtml?page=README_INSTALL.html#oracle-10g-11g" target="_top" rel="nofollow"><span>http://www.maptools.org/ms4w/index.phtml?page=README_INSTALL.html#oracle-10g-11g</span></a><br>
<br>
to enable Oracle 10g support and "mapserv -v" returns a string that contains "INPUT=ORACLESPATIAL"<br>
<br>
<span>In mapfile I have a Layer: </span><br>
<br>
<span>LAYER </span><br>
<span> NAME PSITDATA.COMUNI </span><br>
<span> TYPE POLYGON </span><br>
<span> CONNECTIONTYPE <span class="bold highlight search-highlight">oraclespatial</span></span><br>
<span> CONNECTION "UN/PW@DBSVILPU" </span><br>
<span> DATA "SHAPE FROM PSITDATA.COMUNI USING SRID 32633 VERSION 10g" </span><br>
<span> CLASS </span><br>
<span> STYLE </span><br>
<span> OUTLINECOLOR 0 0 0 </span><br>
<span> COLOR 0 128 128 </span><br>
<span> END </span><br>
<span> END </span><br>
<span> METADATA </span><br>
<span> "wms_title" "PSITDATA.COMUNI" </span><br>
<span> #"wms_srs" "EPSG:26591" </span><br>
<span> "wms_srs" "EPSG:32633" </span><br>
<span> "wms_name" "PSITDATA.COMUNI" </span><br>
<span> "wms_server_version" "1.1.1" </span><br>
<span> "wms_format" "image/png" </span><br>
<span> "wms_enable_request" "*" ##necessary </span><br>
<span> END </span><br>
<span> PROJECTION </span><br>
<span> "init=epsg:32633" </span><br>
<span> END </span><br>
<span>END </span><br>
<br>
<br>
<span>but I have the error: </span><br>
<br>
<br>
<b><span>ORA-06553: PLS-306: wrong number or types of arguments in call to 'SDO_FILTER'</span></b><br>
<span> . 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.
</span><br>
<br>
<span>When I tried the SELECT in SQL*PLUS I had obtained: </span><br>
<br>
<b><span>SP2-0552: Bind variable "ORDINATES" not declared</span></b><br>
<br>
<span>Can you help me with the this error and with mapfile <span class="bold highlight search-highlight">
syntax</span>? </span><br>
<br>
<span>Thank you </span><br>
<span>Michele </span>_______________________________________________ mapserver-users mailing list
<a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a></span><br>
<br>
</span>
</body>
</html>