[mapserver-users] oracle8.1.7 and mapserver

[nida Khan]

Hi,

Thank you so much Yu-Hsin for your reply,
luckily I found a windows binary for oracle on some site!
It works fine when it reads a shape file, but when I try to connect to oracle database it does'nt any image! as if it didnt find any thing (nothing in log file either).

I've got a demo data from "mapviewer" in my oracle database!
and this is what I'm using in my layer

(this is a example layer from postgres)

NAME ORA
EXTENT -159.6 28.77 -71.4667 70.5
SIZE 400 300
LAYER # start of the "cities" layer object
  CONNECTIONTYPE oraclespatial
  NAME "cheshire"
  CONNECTION scott/tiger at MYDB
  DATA "select geom from cities"
  #FILTER "city = 'Albany' "
  STATUS DEFAULT
  TYPE POINT
  CLASS
    COLOR 120 120 220
    OUTLINECOLOR 10 10 0
  END # end of class object
END # end of layer object
END # end of map file

(from my Oracle db)
SQL> select * from cities where city='Albany';

LOCATION(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_INFO, SDO_ORDINATES)
--------------------------------------------------------------------------------
CITY                                       ST      POP90     RANK90
------------------------------------------ -- ---------- ----------
SDO_GEOMETRY(2001, NULL, SDO_POINT_TYPE(-73.799017, 42.66575, NULL), NULL, NULL)
Albany                                     NY     101082        192


Now is there anything I need to change in the layer to get this data from the database???

I really appreciate your help!
Kind Regards
Nida.

  ----- Original Message ----- 
  From: Yu-Hsin Chen 
  To: nida Khan ; mapserver-users at lists.gis.umn.edu 
  Sent: Friday, November 15, 2002 1:34 PM
  Subject: RE: [mapserver-users] oracle8.1.7 and mapserver


  Nida:

  You need to compile MapServer with oraclespacial.

  Your Oracle RDBMS needs to have Spacial option loaded.  Hopefully you've already got this part, it is a good learning curve if you havn't.

  What web server are you using?  You might need to modify the configuration a little.

  Once you have all the correct environment and settings it WILL work.  I'm running MapServer on a Mandrake Linux server accessing Oracle 8.0.5 data on a UnixWare server through CGI.

  Yu-Hsin
    -----Original Message-----
    From: nida Khan [mailto:nida at webstar.co.uk]
    Sent: Friday, November 15, 2002 6:29 AM
    To: mapserver-users at lists.gis.umn.edu
    Subject: [mapserver-users] oracle8.1.7 and mapserver


    Hi Everyone,

    Is there anyway to connect to Oracle 8.1.7 database on Solaris via Mapserver?
    I've compiled Mapserver with Postgress, but have no idea how to do it for Oracle now!

    I would really appreciate if anyone can guide me to right documentation or just give me some codes!!!!

    Looking forward for your replies

    Regards
    Nida.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20021115/d67364c8/attachment.htm>