[Mapserver-users] Unable to display data stored in Oracle Spatial

[Jiri Potocny]

Dear MapServer experts,

could you please help me with following problem?

I'm trying to display data strored in Oracle Spatial, but I allways get a
blank map.
The map file is as follows:

MAP
  IMAGETYPE      PNG
  EXTENT -551051 -1288960 -548185 -1286773
  SIZE           800 600
  IMAGECOLOR     255 255 255

  LAYER
    NAME           parcels
    DUMP           TRUE
    STATUS         DEFAULT
    TYPE           POLYGON

    CONNECTIONTYPE oraclespatial
    CONNECTION     username/password at netservisname
    DATA           "BOUNDARY FROM PARCELS"

    CLASS
      COLOR        232 232 232
      OUTLINECOLOR 32 32 32
    END
  END

END

If I export the data from oracle into the shapefile and use following map
file, everything is O.K.

MAP
  IMAGETYPE      PNG
  EXTENT -551051 -1288960 -548185 -1286773
  SIZE           800 600
  SHAPEPATH      "data"
  IMAGECOLOR     255 255 255

  LAYER
    NAME           parcely
    DUMP           TRUE
    STATUS         DEFAULT
    TYPE           POLYGON
    DATA          PARCELS

    CLASS
      COLOR        232 232 232
      OUTLINECOLOR 32 32 32
    END
  END

END

The only difference is in the data source, the data (attributes as well as
geometries) are the same. I'm running MapServer 4.0.1 with Oracle Spatial
support (downloaded from
http://hypnos.cbs.umn.edu/projects/downloads/ms401_png_oracle.zip) and
Oracle Database Server version 9.2.0.1.0 on Windows 2000 Professional SP 3.

Could anybody get throught this problem.

Much appreciated,
Jirka