oracle spatial

Simon Guerard guerardsimon at HOTMAIL.COM
Mon Sep 13 06:12:32 EDT 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