Hi All,

<br>

Thanks all for the solution of my previous query ( Problem in Oracle Spatial Connection - Empty Image).

<br>

Now I got new query, Please give me some solution.

<br>

<br> I am able to establish connection between MapServer and Oracle Spatial 10g, and we can get the Map Image prefectly ( refer Subject <i>Problem in Oracle Spatial Connection - Empty Image</i>)

<br>

I am unable to get the any Query  Function in MapServer with Oracle Spatial , but i can able to do the query operation with Shapefiles.

<br>

<br> The Mapfile, quey and Error is give below,

<br>

<br><b>Mapfile</b>

<br>

<br>        MAP

<br>                DEBUG ON

<br>                NAME           World_Country

<br>                EXTENT        -180 -90 180 83.60415649414

<br>                SIZE           800 400

<br>                SHAPEPATH      '/ms4w/apps/zap/data/'

<br>                IMAGETYPE      GIF

<br>                STATUS       ON

<br>

<br>                WEB

<br>                        TEMPLATE     'templates/ZapTemp.html'

<br>                        IMAGEPATH    '/ms4w/tmp/ms_tmp/'

<br>                        IMAGEURL     '/ms_tmp/'

<br>                END

<br>

<br>                PROJECTION

<br>                        "proj=latlong"

<br>                        "ellps=WGS84"

<br>                END

<br>

<br>                QUERYMAP

<br>                        STATUS    ON

<br>                        STYLE     HILITE

<br>                        COLOR     255 255 0

<br>                END

<br>

<br>                LAYER 

<br>                        DEBUG ON

<br>

<br>                        PROJECTION

<br>                                "proj=latlong"

<br>                                "ellps=WGS84"

<br>                        END

<br>

<br>                        CONNECTIONTYPE oraclespatial

<br>                        CONNECTION "world/land@orcl"

<br>                        DATA "shape FROM world USING SRID 8307"

<br>

<br>                        NAME         world_poly

<br>                        STATUS       ON

<br>                        TYPE         POLYGON

<br>

<br>

<br>                        DUMP TRUE

<br>

<br>                        TEMPLATE "templates/ZapTemp.html"

<br>

<br>                        TOLERANCE 5

<br>

<br>                        CLASS

<br>                                NAME  'The_World'

<br>                                        STYLE

<br>                                        COLOR    0 200 0

<br>                                END

<br>                        END

<br>                END 

<br>        END

<br>

<br>

<br><b>Query</b>

<br>

<br><b><a href="http://localhost/cgi-bin/mapserv.exe?map=/ms4w/apps/zap/htdocs/CountryOrcl.map&mode=itemnquery&layer=world_poly&qlayer=world_poly&qitem=cntry_name&qstring=india" target="_top" rel="nofollow">http://localhost/cgi-bin/mapserv.exe?map=/ms4w/apps/zap/htdocs/CountryOrcl.map&mode=itemnquery&layer=world_poly&qlayer=world_poly&qitem=cntry_name&qstring=india</a></b>

<br>

<br>

<br><b>Error Message</b>

<br>

msOracleSpatialLayerWhichShapes(): OracleSpatial error. Error: ORA-00920: invalid relational operator . Query statement: SELECT rownum, cntry_name, shape FROM world WHERE india AND SDO_FILTER( shape, MDSYS.SDO_GEOMETRY(2003, 8307, NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-180,-90,180,83.6041565) ),'querytype=window') = 'TRUE' . Check your data statement.

<br>

<br><b>Spatial data in Oracle</b>

<br>

<br>SQL> describe world

<br>

<br> Name                                      Null?    Type

<br> ----------------------------------------- -------- ----------------------------

<br>

<br> SHAPEID                                   NOT NULL NUMBER(38)

<br> FIPS_CNTRY                                         VARCHAR2(2)

<br> GMI_CNTRY                                          VARCHAR2(3)

<br> ISO_2DIGIT                                         VARCHAR2(2)

<br> ISO_3DIGIT                                         VARCHAR2(3)

<br> CNTRY_NAME                                         VARCHAR2(254)

<br> LONG_NAME                                          VARCHAR2(40)

<br> SOVEREIGN                                          VARCHAR2(40)

<br> POP_CNTRY                                          NUMBER

<br> CURR_TYPE                                          VARCHAR2(16)

<br> CURR_CODE                                          VARCHAR2(4)

<br> LANDLOCKED                                         VARCHAR2(1)

<br> SQKM                                               NUMBER

<br> SQMI                                               NUMBER

<br> COLORMAP                                           NUMBER

<br> SHAPE                                              MDSYS.SDO_GEOMETRY

<br>

<br>

<br> Please give me a some solution 

<br>

<br> Waiting for the reply

<br>

<br>Thanks & Regards,

<br>Prema Selvam

<br>GISbiz

<br>

<br>

<br><hr align="left" width="300">

View this message in context: <a href="http://www.nabble.com/Problem-in-Oracle-Spatial-with-MapServer-in-ItemnQuery-t945593.html#a2449588">Problem in Oracle Spatial with MapServer in ItemnQuery</a><br>

Sent from the <a href="http://www.nabble.com/Mapserver---User-f1215.html">Mapserver - User</a> forum at Nabble.com.