[Mapserver-users] spatial from ORACLE 9.2.0.1 support

[Bart van den Eijnden]

Hi,

It should work with 9.2.0.1.

Did you get the error messages from the debug file? If you do not have the 
debug file turned on, can you turn it on and see if there are any ORA 
queries / messages in it?

Can you also give it a try with a syntax like this one:
DATA "GEOMETRIE FROM KWADRANTEN USING SRID 90112"

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

Best regards,
Bart

On Thu, 28 Aug 2003 07:13:51 -0700, Hong, Sung-Hyuk 
<SHHong at mednet.ucla.edu> wrote:

> 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
>
>



--