Mapserver native oracle connection should not use ORACLE_HOME -parameter

[Fernando Simon]

Hi folks,
    The environment variable is a good way how to define where the files 
can be found, you don't need to define a long parameter. But in 
Mapserver you can use two ways: ORACLE_HOME environment, or the direct 
path for Oracle home/libs. So you can compile the native connection 
without the ORACLE_HOME environment.
    The ORACLE_HOME can indicate Database server, Oracle Client, or IAS. 
For native connection you need to have, in the system, the Oracle Call 
Interfaces (OCI). Here in my computer I have the database and Mapserver 
without problems. The OCI can be found in Client, Database server, and IAS.
    The error that Steve related is with the Oracle Instant Client, some 
libraries in Instant Client is not the same as a normal (Client/Server) 
installation.
    Best regards.

------------------------------------------------------------------------
Fernando Simon
Mapserver and Oracle Spatial developer
G10 - Laboratorio de Computacao Aplicada - Brazil
http://www.univali.br/g10 - UNIVALI/CTTMAR
------------------------------------------------------------------------

Steve Lime wrote:
> In my experience (of 2 days) the Oracle Spatial support build process 
> works best with it but with a quick hack of the Makefile you can work around that. The build problem is a known issue and there's bug related to this already filed (1470). That bug contains the build workaround.
>
> Once built the support doesn't need ORACLE_HOME.
>
> Steve
>
>   
>>>> Jukka Sirviö <jukka.sirvio at ARBONAUT.COM> 01/21/06 9:24 AM >>>
>>>>         
> Hello!
> MapServer native oracle connection uses ORACLE_HOME enviroment variable,
> variable should point to client installation directory. If the main
> database (and probaply also other oracle software, for example AS and/or
> Oracle Lite) reside in same hardware then this kind of use of this
> specific enviroment variable can cause problems.
>
> My opinion is that Mapserver should work independently from ORACLE_HOME -
> enviroment variable? Comment's?
>
> -Jukka S-
>
>