[Mapserver-users] spatial from ORACLE 9.2.0.1 support

[Hong, Sung-Hyuk]

Does mapserver support spatial from oracle 9.2.0.1?
Next, I describe my problem.

1. DOWNLOADED the mapserver 4.0 mapserver-4.0.tar.gz
2. COMPILED with oracle 9.2.0.1 in Linux OS
   ./configure --prefix=/usr --with-proj --with-gdal --with-ogr
--with-wfsclient --with-oraclespatial=/m01/app/oracle/product/9.2.0.1
   make
   make install
3. INSTALLED the demo and it did run very well
4. CREATED my own ora.map

   MAP
     EXTENT -2400000 1200000 -1600000 2500000
     IMAGECOLOR 200 200 200 #IMAGECOLOR [r] [g] [b]
     INTERLACE ON #INTERLACE [on|off]
     NAME demo
     SIZE 600 600 #SIZE [x][y]
     STATUS ON #STATUS [on|off]
     UNITS meters #UNITS [feet|inches|kilometers|meters|miles|dd]
     LAYER
       TYPE point
       NAME demo
       STATUS default
       CONNECTIONTYPE oraclespatial
       CONNECTION 'scott/tiger at d2dev'
       DATA "GEOMETRY from (select GEOMETRY from PROJ_PATIENT)"
          CLASS
            OUTLINECOLOR 0 255 0
            COLOR 255 0 0
          END
       END
    END
   
5.  TEST from the local hard drive using     
    ./mapserv
"QUERY_STRING=map=/home/nsadmin/servers/server1/pages/itasca/ora.map&mode=ma
p"
    
    FAILED with 
    msDrawMap(): Image handling error. Failed to draw layer named 'demo'.
    msOCIConnect() in msOracleSpatialLayerOpen(): OracleSpatial error.  

    NOTE: when run against the demo.map, it dump an image to stdout.

Please help!

Thank you in advance,

Sung