[Mapserver-users] Querying an Oracle Spatial with MS

[Michael Schulz]

Hi,
did you compile mapserver with the option --with-oraclespatial=/dir/to/orahome ?
You can check this by executing mapserv from the commandline with the -v option: if
it is enabled you should find "INPUT=ORACLESPATIAL" in the ouput.

Cheers, Michael


Roberto_Santinelli schrieb:

>   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
> _______________________________________________
> Mapserver-users mailing list
> Mapserver-users at lists.gis.umn.edu
> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users

--
-----------------------------------------------------------
Michael Schulz                                in medias res
Dipl.-Geologe                              Gesellschaft für
                                Informationstechnologie mbH
                             Sautierstr. 38, 79104 Freiburg
                                     0761 55695-95 (Fax 96)
mschulz at webgis.de                             www.webgis.de