[Mapserver-users] Querying an Oracle Spatial with MS

Roberto_Santinelli Roberto.Santinelli at pg.infn.it
Thu Mar 6 03:56:32 EST 2003


  Hi everybody,
once discovered the possiblity to retrieve data from a Database, i just
tried to query my DBMS Oracle Spatial in the hope to display a shape layer i 
know to be correctly populating the column GEOM of the table Particelle2 as 
SDO_GEOMETRY object...

The syntax i used is resumed in the following lines (by the way i believe it's 
all right)  
 

*************************************************************
LAYER
  NAME particelle2
  TYPE polygon
  STATUS default
  MAXSCALE 1000000
  CONNECTIONTYPE oraclespatial
  CONNECTION 'scott/tiger at escora.sitweb.it' #this is the DB
  DATA "GEOM from PARTICELLE2"
  CLASS
    NAME 'county'
    COLOR 220 224 230
    OUTLINECOLOR 0 0 0
  END

END #layer
******************************************************************

But i have back as answer from MapServer (version 3.7 under W2K) the following:

"msOracleSpatialLayerOpen(): OracleSpatial error. OracleSpatial is not 
supported "


Certainly the problem is in the unsupported OracleSpatial component.
 But i'm not sure if the problem reside in the version used of MapServer dues 
to the fact the it tried to use the msOracleSpatialLayerOpen() method.
It sounds like something elsewere is wrong, 
but i don't know what....

Some hints or suggestions?

Thanks in advance for every kind of help,
Roberto



More information about the mapserver-users mailing list