Well, I have no problems. I'm running the same version of MapServer 5.2,
however I think I'm only running IC 10.2. What I have in my map file is;
LAYER
GROUP "Switch Boundaries"
NAME "Kentwood"
TYPE POLYGON
STATUS OFF
CONNECTIONTYPE oraclespatial
CONNECTION "username/[EMAIL PROTECTED]"
PROCESSING "CLOSE_CONNECTION=DEFER"
DATA "geom FROM (SELECT swt.switch_descr, sgt.geom FROM ms_switch_vw swt,
switch_geom_tab sgt WHERE swt.switch_id = sgt.switch_id AND swt.switch_id = 5)
USING SRID 8307"
LABELITEM "switch_descr"
METADATA
"static_legend" "1"
END
DUMP true
TRANSPARENCY 100
CLASS
MINSCALE 5200000
MAXSCALE 41000000
STYLE
SYMBOL "circle"
OUTLINECOLOR 80 80 80
SIZE 1
END
END
CLASS
MINSCALE 0
MAXSCALE 5200000
STYLE
SYMBOL "circle"
OUTLINECOLOR 80 80 80
SIZE 2
END
END
END
I have many layers like this that work without a problem.
----
Timothy J Nolte - [EMAIL PROTECTED]
Network Planning Engineer
iPCS Wireless, Inc.
4717 Broadmoor Ave, Suite G
Kentwood, MI 49512
Office: 616-656-5163
PCS: 616-706-2438
Fax: 616-554-6484
Web: www.ipcswirelessinc.com
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of FCampos
> Sent: Wednesday, August 06, 2008 8:10 AM
> To: mapserver-users@lists.osgeo.org
> Subject: RE: [MAPSERVER-USERS] mapserver does not show oracle layer
>
>
> Yes.
>
> Mapserver, I´ve got:
> MapServer version 5.2.0 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP
> OUTPUT=PDF
> OUTPUT=SWF OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=AGG SUPPORTS=FREETYPE
> SUPPORTS=ICO
> NV SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER
> SUPPORTS=WFS_CLIE
> NT SUPPORTS=WCS_SERVER SUPPORTS=SOS_SERVER SUPPORTS=FASTCGI
> SUPPORTS=THREADS
> SUP
> PORTS=GEOS SUPPORTS=RGBA_PNG INPUT=JPEG INPUT=POSTGIS
> INPUT=ORACLESPATIAL
> INPUT=
> OGR INPUT=GDAL INPUT=SHAPEFILE
>
> Oracle:
> instantclient 11.1 with a tnsnames.ora definition.
>
> If i put a bad sql, it gives a oci error, so it´s compiled.
>
> msOracleSpatialLayerWhichShapes(): OracleSpatial error. Error parsing
> OracleSpatial DATA variable. Must be:'geometry_column FROM
> table_name [USING
> UNIQUE <column> SRID srid# FUNCTION]' or ...
> --
> View this message in context:
> http://www.nabble.com/mapserver-does-not-show-oracle-layer-tp1
> 8847632p18849791.html
> Sent from the Mapserver - User mailing list archive at Nabble.com.
>
> _______________________________________________
> mapserver-users mailing list
> mapserver-users@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>
_______________________________________________
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
