oracle spatial
Simon Guerard
guerardsimon at HOTMAIL.COM
Mon Sep 13 03:12:32 PDT 2004
Hello mapserver-users !
I try to draw data from oracle spatial and I've got this message :
Mon Sep 13 12:04:00 2004 - msOracleSpatialLayerWhichShapes(): OracleSpatial
error. ORA-29902: erreur d'exécution de la routine ODCIIndexStart()
ORA-13208: erreur interne lors de l'évaluation de l'opérateur [window SRID
does not match layer SRID]
ORA-06512: à "MDSYS.SDO_INDEX_METHOD_9I", ligne 232
ORA-06512: à ligne 1
. SQL statement: SELECT rownum, GEOLOC FROM TEST1 WHERE SDO_FILTER(
TEST1.GEOLOC, MDSYS.SDO_GEOMETRY(2003, NULL, NULL,MDSYS.SDO_ELEM_INFO_ARRAY
(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-4,-2,4,2) ),'querytype=window')
= 'TRUE'
Mon Sep 13 12:04:00 2004 - msDrawMap(): Image handling error. Failed to
draw layer named 'test_ora'.
If anybody has an idea ?
My mapfile :
LAYER
NAME "test_ora"
METADATA
"DESCRIPTION" "Test_ora"
"RESULT_FIELDS" "OBJECTID"
"RESULT_LIBELLE" "id"
"LEGENDE" "1"
"LEGENDE_COLOR" "00FFFF"
"TYPE_LAYER" "ORA"
"ACTIVE_LEVEL" "1"
END
STATUS ON
CONNECTIONTYPE oraclespatial
CONNECTION "simon/gilm at epcenter"
DATA "GEOLOC FROM TEST1"
TYPE POINT
CLASS
TEMPLATE "obj_del.html"
NAME "test_ora"
TITLE "Niveau mapinfo"
END
END
END #END MAPFILE
More information about the MapServer-users
mailing list