[Mapserver-users] oracle spatial mapfile

[Sylvain Beorchia]

Hi,

oci.dll is in C:\oracle\ora81\bin\
With oracle spatial i want to draw some polygons, points and texts.

----- Original Message ----- 
From: "Fernando S." <simon at inf.univali.br>
To: "Sylvain Beorchia" <sbeorchia at gi-lemans.fr>;
<mapserver-users at lists.gis.umn.edu>
Sent: Monday, June 14, 2004 3:05 PM
Subject: Re: [Mapserver-users] oracle spatial mapfile


> Hi Sylvain,
>     Try to find in your system where are "oci.dll" (windows) or "oci.h"
> (linux).
>     And one more question, what do you want draw using
> mapserv/oraclespatial?
>
> --------------------------------------------------------------------------
---------
> Fernando Simon
> Data Base Manager, Mapserv and Oracle Spatial developer
> G10 - Laboratorio de Computacao Aplicada
> g10.cttmar.univali.br
> --------------------------------------------------------------------------
----------
>
> Sylvain Beorchia wrote:
>
> >RE: [Mapserver-users] oracle spatial mapfileHi, thanks.
> >In fact my Mapserv.exe support Oracle. And i still got the error.
> >What is exactly the oracle client dll ? i have Oracle 8.1.7 server
installed
> >on my pc.
> >And do i have to include some SETENV var in my httpd.conf in Apache ? :
> >
> >    SetEnv ORACLE_SID spa
> >    SetEnv ORACLE_BASE "c:/oracle"
> >    SetEnv ORACLE_HOME "c:/oracle/ora81"
> >    SetEnv ORA_NLS33 "c:/oracle/ora81/ocommon/nls/admin/data
> >    SetEnv NLS_LANG "AMERICAN AMERICA"
> >
> >Thank u.
> >
> >----- Original Message ----- 
> >From: Smith, Michael ERDC-CRREL-NH
> >To: 'Sylvain Beorchia ' ; 'mapserver-users at lists.gis.umn.edu '
> >Sent: Saturday, June 12, 2004 2:06 PM
> >Subject: RE: [Mapserver-users] oracle spatial mapfile
> >
> >
> > Sylvain,
> >The error message indicates that Oracle Spatial support was not compiled
in
> >to mapserver. If you are using the unix/linux version you will need to
> >add --with-oraclespatial=/path/to/oraclehome option to your configure
> >command and re-make the build. If you are using Windows, there is a build
> >including oraclespatial on the Mapserver download page but you'll need
the
> >oracle client dll's from otn.oracle.com .
> >In either case, the data string is "geometry_column from table_name" so
> >GEOLOC needs to be your geometry column. If you loaded your spatial data
> >using OGR, the column is probably called ogr_geometry.
> >Mike Smith
> >ERDC/USACE
> >michael.smith at erdc.usace.army.mil
> >-----Original Message----- 
> >From: Sylvain Beorchia
> >To: mapserver-users at lists.gis.umn.edu
> >Sent: 6/11/2004 5:52 AM
> >Subject: [Mapserver-users] oracle spatial mapfile
> >Hi list,
> >I try to display some data from oracle spatial in my mapserver project.
> >It
> >doesn't work.
> >Here is my mapfile layer:
> >LAYER
> >    NAME spa
> >    METADATA
> >        "DESCRIPTION" "Spatial"
> >        "LEGENDE" "1"
> >        "TYPE_LAYER" "ORA"
> >    END
> >    STATUS ON
> >    CONNECTIONTYPE oraclespatial
> >    CONNECTION "spa/sig at spa"
> >    DATA "GEOLOC from FP10010_LINES"
> >    TYPE LINE
> >    CLASS
> >        OUTLINECOLOR 0 0 0
> >        COLOR 0 128 128
> >    END
> >  END
> >The data in the database are from some Mapinfo TabFiles. SO i've got a
> >table
> >FP10010_LINES with the GEOLOC field, that's why i've tried to retreive
> >data
> >with "GEOLOC from FP10010_LINES".
> >So, when i launch my IE, i've got the following errors :
> >    "Warning: MapServer Error in msOracleSpatialLayerOpen():
> >OracleSpatial
> >is not supported in C:\ms4w\apps\gmap\htdocs\gmap.php3 on line 616"
> >    "Fatal error: Call to a member function on a non-object in
> >C:\ms4w\apps\gmap\htdocs\gmap.php3 on line 617"
> >
> >
> >My oracle version is 8i (8.1.7)
> >Any ideas ?
> >Thank u.
> >_______________________________________________
> >Mapserver-users mailing list
> >Mapserver-users at lists.gis.umn.edu
> >http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
> >
> >_______________________________________________
> >Mapserver-users mailing list
> >Mapserver-users at lists.gis.umn.edu
> >http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
> >
> >
> >
>