Thank you Michael,<br><br>I tried without version but with the same result.<br><br>Michele<br><br>
<br>
----Messaggio originale----<br>
Da: Michael.Smith@erdc.dren.mil<br>
Data: 20-ago-2012 17.53<br>
A: "Michele De Santis"<tape2m@virgilio.it>, "mapserver-users@lists.osgeo.org"<mapserver-users@lists.osgeo.org><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>