[Mapserver-users] spatial from ORACLE 9.2.0.1 support

[Timothy.Mackey at ga.gov.au]

Yes, we have compiled 4.0 and have Oracle spatial support going against
9.2.0.1.0 on Solaris.

Have you got the following environment variables set in your web server?
ORACLE_SID
TWO_TASK
ORACLE_HOME
TNS_ADMIN


Tim Mackey
Webmaster
Geoscience Australia
timothy.mackey at ga.gov.au
http://www.ga.gov.au



-----Original Message-----
From: Hong, Sung-Hyuk [mailto:SHHong at mednet.ucla.edu]
Sent: Friday, 29 August 2003 12:14 AM
To: 'mapserver-users at lists.gis.umn.edu'
Subject: [Mapserver-users] spatial from ORACLE 9.2.0.1 support


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
_______________________________________________
Mapserver-users mailing list
Mapserver-users at lists.gis.umn.edu
http://lists.gis.umn.edu/mailman/listinfo/mapserver-users