[mapserver-users] Antwort: msOracleSpatialLayerGetShape(): OracleSpatial error. Error: ORA-00932
dzizes
dzizes451 at gmail.com
Thu Feb 5 00:47:53 PST 2009
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.
More information about the MapServer-users
mailing list