Problem with Oraclespatial connection

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Problem with Oraclespatial connection

miki79
This post has NOT been accepted by the mailing list yet.
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

In my 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