[Mapserver-users] oracle spatial mapfile

[Sylvain Beorchia]

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