[mapserver-users] Antwort: msOracleSpatialLayerGetShape(): OracleSpatial error. Error: ORA-00932

[dzizes]

Hello!

 LAYER NAME "GEOM" STATUS ON
                TYPE POLYGON

                #MAXSCALE 110000

                PROCESSING "CLOSE_CONNECTION=DEFER"
                CONNECTIONTYPE oraclespatial
                CONNECTION "asdasd/asdasd at GIS"
                DATA "GEOMETRIA FROM V_GEOM USING UNIQUE ID VERSION 10g"

                DUMP TRUE
                DEBUG 5
                METADATA
                      "wms_title" "V_GEOM"
                      "wms_srs" "EPSG:4326"
                      "wms_include_items" "ID"
                END

                TEMPLATE "blank.html"
                PROJECTION
                        "proj=longlat"
                        "ellps=WGS84"
                        "datum=WGS84"
                        "no_defs"
                END
        END

Below tail of MapServer Log:
[Thu Feb  5 09:30:00 2009].520573 msOracleSpatialLayerFreeItemInfo was
called.
[Thu Feb  5 09:30:00 2009].520671 msOracleSpatialLayerWhichShapes was
called.
[Thu Feb  5 09:30:00 2009].520756 msOracleSpatialLayerWhichShapes. Using
this Sql to retrieve the data: SELECT ID, GEOMETRIA FROM V_GEOM WHERE
SDO_FILTER( GEOMETRIA, MDSYS.SDO_GEOMETRY(2003, NULL,
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(18.5535453,53.937141,18.6345023,54.0180979)
),'querytype=window') = 'TRUE'
[Thu Feb  5 09:30:00 2009].799125 msOracleSpatialLayerFreeItemInfo was
called.
[Thu Feb  5 09:30:00 2009].799230 msOracleSpatialLayerClose was called.
Layer name: GEOM. Layer connection: asdasd/asdasd at GIS
[Thu Feb  5 09:30:00 2009].799268 msOracleSpatialLayerClose. Cleaning
layerinfo handlers.
[Thu Feb  5 09:30:00 2009].799502 msOracleSpatialLayerClose. Cleaning Oracle
Cache.
[Thu Feb  5 09:30:00 2009].799898 msOracleSpatialLayerClose. Release the
Oracle Pool.
[Thu Feb  5 09:30:00 2009].799912 

When executing the spatial query found in log file it works fine.

GetFeatureInfo works fine.
-- 
View this message in context: http://n2.nabble.com/msOracleSpatialLayerGetShape%28%29%3A-OracleSpatial-error.-Error%3A-ORA-00932-tp2268870p2273833.html
Sent from the Mapserver - User mailing list archive at Nabble.com.