oracle spatial

[Smith, Michael ERDC-CRREL-NH]

If your data has an SRID assigned use something like

DATA "GEOLOC FROM TEST1 USING SRID XXXX"

where xxxx  is the SRID number of your data.

Mike Smith


-----Original Message-----
From: Simon Guerard
To: MAPSERVER-USERS at LISTS.UMN.EDU
Sent: 9/13/2004 6:12 AM
Subject: [UMN_MAPSERVER-USERS] oracle spatial

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20040913/7c28ffb4/attachment.html