[Mapserver-users] oracle spatial mapfile

[Fernando S.]

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
>
>  
>