Problems to visualize data from oracle

[Bart van den Eijnden]

Don't use SELECT in your DATA statement.

http://mapserver.gis.umn.edu/cgi-bin/wiki.pl?OracleSpatial

Bart

Bart van den Eijnden
Syncera IT Solutions
Postbus 270
2600 AG  DELFT

tel.nr.: 015-7512436
email: BEN at Syncera-ITSolutions.nl

>>> Fernando Javier Luyo Zegarra <fluyoz at HOTMAIL.COM> 09/08/05 4:13 am >>>
Hello
I have problems to generate the maps correctly.
use oracle 10g. and Mapserver the 4,4 
the syntaxes of the Mapfile is:

MAP
   
    IMAGECOLOR     255 255 255
    IMAGETYPE      PNG  
    INTERLACE    ON
    NAME "NANITO"
    EXTENT         0 0 20 20
    SIZE           400 500
    SHAPEPATH      "data"
    STATUS ON
    UNITS meters
    TEMPLATEPATTERN "printable.html|loader.html"
    FONTSET "fonts/fonts.list" 
    WEB                           
       LOG "log/map.log"  
      METADATA
          "wms_title" "PRUEBA MapSBN"
          "wms_onlineresource"
          "http://192.168.1.188/cgi-bin/mapserv_44.exe?map=C:\Archivos de
programa\Apache Group\Apache2\htdocs\tutorial\webmapsbn\WebMapSbn.map&"
   "wms_srs" "EPSG:4269 EPSG:4326"
       END # metadata
  TEMPLATE "c:\Archivos de programa\Apache
Group\Apache2\htdocs\tutorial\webmapsbn\printable.html"
  EMPTY "http://192.168.1.188/tutorial/webmapsbn/info.html"  # path relative
to the webserver document root
  #MINSCALE 1000
  #MAXSCALE 1550000
  IMAGEPATH "c:\Archivos de programa\Apache
Group\Apache2\htdocs\tutorial\webmapsbn\tmp\"  # full path to image tmp dir,
so cgi can find it
  IMAGEURL "http://192.168.1.188/tutorial/webmapsbn/tmp/"  # url location of
image tmp dir, so web browser can find it              
  END # fin de web
 
# Start of LAYER DEFINITIONS ---------------------------------------------
  LAYER # this layer problems not to visualize
      NAME         "shape"
       DATA     EJEM_region
      TYPE         POLYGON
     STATUS      DEFAULT    
     #PROJECTION
     #  "init=epsg:26912" 
     #END # fin projection
       CLASS
          COLOR        284 250 232
        OUTLINECOLOR 35 13 32
       END # fin class
  END # fin layer
 
 LAYER # CAPA DE ORACLE
    NAME        "CAPA_ORACLE"       
    DATA     'SELECT GEOM FROM EJEMGIS'
      TYPE         POLYGON
     CONNECTIONTYPE oraclespatial
     CONNECTION "SCOTT/password at ORCL_192.168.1.199"    
    DUMP TRUE  
     STATUS      on
    TEMPLATE "Sinabip_qry.html"    
       CLASS
          OUTLINECOLOR 0 0 0
     COLOR        0 128 128        
       END # fin class
  END # fin layer 
END # end of map file/object


I wait for its recommendations

Fernando Luyo