[MAPSERVER-USERS] mapserver does not show oracle layer

[Nolte, Tim]

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/password at SID"
    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 - tnolte at ilpcs.com
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: mapserver-users-bounces at lists.osgeo.org 
> [mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of FCampos
> Sent: Wednesday, August 06, 2008 8:10 AM
> To: mapserver-users at 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 at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
> 
>