[mapserver-users] Blank image generated from oracle spatial layer.

[DebasishS at riskinc.com]

Hi,

Am working on NT with Mapserver 3.5 . The problem is mapserver is
generating a blank white image for the oracle spatial layer.
Am i missing out something. The description of map file is as follows

#
# Start of map file
#
NAME DEMO
STATUS ON
SIZE 600 600
EXTENT -180 -90 180 90
UNITS METERS
SHAPEPATH "data"
#IMAGECOLOR 255 255 255

#IMAGETYPE PNG

#
# Projection definition, consult the PROJ.4 documentation for parameter
discussion
#
#PROJECTION
#  "proj=utm"
#  "ellps=GRS80"
#  "zone=15"
#  "north"
#  "no_defs"
#END

#
# Start of web interface definition
#
WEB
  HEADER demo_header.html
  TEMPLATE demo.html
  FOOTER demo_footer.html
  #MINSCALE 1000
  #MAXSCALE 1550000
  IMAGEPATH "D:\Program Files\Apache Group\Apache2\htdocs\itasca\tmp"
  IMAGEURL "/tmp/"
  # LOG "demo.log"
END

QUERYMAP
  SIZE 200 200
  STATUS ON
  STYLE HILITE
  COLOR 255 0 0
END

#
# Start of reference map
#
REFERENCE
  IMAGE graphics/reference.gif
  EXTENT -178.21 18.92 -66.96 71.40
  SIZE 120 120
  STATUS ON
  COLOR -1 -1 -1
  OUTLINECOLOR 255 0 0
END

#
# Start of legend
#
LEGEND
  KEYSIZE 18 12
  LABEL
    TYPE BITMAP
    SIZE MEDIUM
    COLOR 0 0 89
  END
  STATUS ON
END

#
# Start of scalebar
#
SCALEBAR
  IMAGECOLOR 255 255 255
  LABEL
    COLOR 255 255 255
    SIZE tiny
  END
  STYLE 1
  SIZE 50 2
  COLOR 255 255 255
  UNITS MILES
  INTERVALS 1
  TRANSPARENT TRUE
  STATUS TRUE
END

#
# Start of layer definitions
#

LAYER
  NAME states
  TYPE polygon
  STATUS default
  CONNECTIONTYPE oraclespatial
  CONNECTION 'system/manager at orcl'
  DATA "GEOM from country"
  CLASS
    NAME 'states'
    COLOR 220 224 230
    OUTLINECOLOR 0 0 0
  END
END
END # Map File




thanks and regards
Debasish Sahu.
Senior Software Engineer
RMS India.