<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2600.0" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2>Hi,</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Thank you so much Yu-Hsin for your reply,</FONT></DIV>
<DIV><FONT size=2>luckily I found a windows binary for oracle on some
site!</FONT></DIV>
<DIV><FONT size=2>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).</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>I've got a demo data from "mapviewer" in my oracle
database!</FONT></DIV>
<DIV><FONT size=2>and this is what I'm using in my layer</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>(this is a example layer from postgres)</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>NAME ORA<BR>EXTENT -159.6 28.77 -71.4667 70.5<BR>SIZE 400
300<BR>LAYER # start of the "cities" layer object<BR> CONNECTIONTYPE
oraclespatial<BR> NAME "cheshire"<BR> CONNECTION <A
href="mailto:scott/tiger@MYDB">scott/tiger@MYDB</A><BR> DATA "select geom
from cities"<BR> #FILTER "city = 'Albany' "<BR> STATUS
DEFAULT<BR> TYPE POINT<BR> CLASS<BR> COLOR 120 120
220<BR> OUTLINECOLOR 10 10 0<BR> END # end of class
object<BR>END # end of layer object<BR>END # end of map file<BR></FONT></DIV>
<DIV><FONT size=2>(from my Oracle db)</FONT></DIV>
<DIV><FONT size=2>SQL> select * from cities where city='Albany';</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>LOCATION(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z),
SDO_ELEM_INFO,
SDO_ORDINATES)<BR>--------------------------------------------------------------------------------<BR>CITY
ST POP90
RANK90<BR>------------------------------------------ -- ----------
----------<BR>SDO_GEOMETRY(2001, NULL, SDO_POINT_TYPE(-73.799017, 42.66575,
NULL), NULL,
NULL)<BR>Albany
NY 101082
192</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Now is there anything I need to change in the layer to get
this data from the database???</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>I really appreciate your help!</FONT></DIV>
<DIV><FONT size=2>Kind Regards</FONT></DIV>
<DIV><FONT size=2>Nida.</FONT></DIV>
<DIV> </DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=ychen@yorktel.com href="mailto:ychen@yorktel.com">Yu-Hsin Chen</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=nida@webstar.co.uk
href="mailto:nida@webstar.co.uk">nida Khan</A> ; <A
title=mapserver-users@lists.gis.umn.edu
href="mailto:mapserver-users@lists.gis.umn.edu">mapserver-users@lists.gis.umn.edu</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, November 15, 2002 1:34
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [mapserver-users]
oracle8.1.7 and mapserver</DIV>
<DIV><FONT size=2></FONT><FONT size=2></FONT><FONT size=2></FONT><BR></DIV>
<DIV><SPAN class=545462213-15112002><FONT face=Arial color=#0000ff
size=2>Nida:</FONT></SPAN></DIV>
<DIV><SPAN class=545462213-15112002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=545462213-15112002><FONT face=Arial color=#0000ff size=2>You
need to compile MapServer with oraclespacial.</FONT></SPAN></DIV>
<DIV><SPAN class=545462213-15112002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=545462213-15112002><FONT face=Arial color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=545462213-15112002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=545462213-15112002><FONT face=Arial color=#0000ff size=2>What
web server are you using? You might need to modify the configuration a
little.</FONT></SPAN></DIV>
<DIV><SPAN class=545462213-15112002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=545462213-15112002><FONT face=Arial color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=545462213-15112002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=545462213-15112002><FONT face=Arial color=#0000ff
size=2>Yu-Hsin</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> nida Khan
[mailto:nida@webstar.co.uk]<BR><B>Sent:</B> Friday, November 15, 2002 6:29
AM<BR><B>To:</B> mapserver-users@lists.gis.umn.edu<BR><B>Subject:</B>
[mapserver-users] oracle8.1.7 and mapserver<BR><BR></FONT></DIV>
<DIV><FONT size=2>Hi Everyone,</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Is there anyway to connect to Oracle 8.1.7 database on
Solaris via Mapserver?</FONT></DIV>
<DIV><FONT size=2>I've compiled Mapserver with Postgress, but have no idea
how to do it for Oracle now!</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>I would really appreciate if anyone can guide me to right
documentation or just give me some codes!!!!</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Looking forward for your replies</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Regards</FONT></DIV>
<DIV><FONT size=2>Nida.</FONT></DIV>
<DIV> </DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>