MapServer and Oracle Spatial

[Nicol Hermann]

Hi,

try setting the variable ORACLE_HOME in your Webserver environment.
HTH
Nicol


Am Dienstag, den 25.01.2005, 16:05 -0800 schrieb Lyndon Tiu:
> Hello,
>
> I have:
>
> 1) Mapserver 4.4.1 on Linux compiled with oraclespatial support.
>
> 2) Oracle Spatial 10g on Solaris.
>
> 3) Tnsnames are configured properly and sqlplus from the Linux command
> line can connect to Oracle database on Solaris box.
>
> 4) Listener and database have both been started and are both running on
> Solaris box.
>
> 5) mapserver map file:
>
>         LAYER
>           NAME "oggma"
>           CONNECTIONTYPE oraclespatial
>           CONNECTION "user/pass at orasptl"
>           DATA "GEOM FROM OGGMA USING SRID NULL"
>           STATUS ON
>           TYPE POLYGON
>           CLASS
>                 STYLE
>                         OUTLINECOLOR 0 0 0
>                         COLOR 225 225 185
>                 END
>           END
>           PROJECTION
>                         "init=epsg:42102"
>         END
>         END
>
> The connect string:
>
> user/pass at ora10g works fine from the command line and from Oracle
> Enterprise Manager so I know tnsnames is configured properly.
>
> Also, the table OGGMA and data are loaded and I can do a select * from
> OGGMA and data would come back fine.
>
>
> 6) Pointing a web browser at mapserver produces the following error:
>
> <?xml version='1.0' encoding="ISO-8859-1" standalone="no" ?>
> <!DOCTYPE ServiceExceptionReport SYSTEM
> "http://schemas.opengeospatial.net/wms/1.1.1/exception_1_1_1.dtd">
> <ServiceExceptionReport version="1.1.1">
> <ServiceException>
> msDrawMap(): Image handling error. Failed to draw layer named
> &#39;ogma&#39;.
> msOracleSpatialLayerOpen(): OracleSpatial error. Cannot create OCI
> Handlers. Connection failure. Check the connection string. Error: .
> </ServiceException>
> </ServiceExceptionReport>
>
>
> Can someone help me with this issue?
>
> Thank you for any tips and suggestions.
>
> --
> Lyndon Tiu