[mapserver-users] oraclespatial connection

[Michele De Santis]

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

	
	
	
	 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20120820/07d87a0e/attachment.htm>