 <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:

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.

</span><br><br><span>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 <span class="bold highlight search-highlight">syntax?

</span><br><br><span>Thank you

</span><br><span>Michele

        </span> 