<!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><SPAN class=246590317-15112002><FONT face=Arial color=#0000ff
size=2>Nida:</FONT></SPAN></DIV>
<DIV><SPAN class=246590317-15112002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=246590317-15112002><FONT face=Arial color=#0000ff
size=2>Judging from your 'counties table with a column geom' it doesn't appear
to me you're using Oracle Spacial option. You will need to have that
option to work with MapServer. Is your 'geom' column of data type
SDO_GEOMETRY?</FONT></SPAN></DIV>
<DIV><SPAN class=246590317-15112002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=246590317-15112002><FONT face=Arial color=#0000ff size=2>You
have to make sure Oracle Spacial option is in the database. By default,
when spacial option is installed you'll have an MDSYS user id and schema
associated with that user. If you don't see that, you'll have to install
it first. You should have an 'md' directory under $ORACLE_HOME.
Under md there is an admin directory which contains all installation
scripts.</FONT></SPAN></DIV>
<DIV><SPAN class=246590317-15112002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=246590317-15112002><FONT face=Arial color=#0000ff size=2>Your
map file looks OK if your counties is a table contain geom column which is of
SDO_GEOMETRY data type.</FONT></SPAN></DIV>
<DIV><SPAN class=246590317-15112002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=246590317-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 9:48
AM<BR><B>To:</B> Yu-Hsin Chen;
mapserver-users@lists.gis.umn.edu<BR><B>Subject:</B> Re: [mapserver-users]
oracle8.1.7 and mapserver<BR><BR></FONT></DIV>
<DIV><FONT size=2>I gave wrong example! :(</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>here is the right example</FONT></DIV>
<DIV><FONT size=2>layer defination</FONT></DIV>
<DIV><FONT size=2>LAYER<BR> NAME counties<BR> TYPE
polygon<BR> STATUS default<BR> MAXSCALE 1000000<BR>
CONNECTIONTYPE oraclespatial<BR> CONNECTION <A
href="mailto:'scott/tiger@PHAR'">'scott/tiger@PHAR'</A><BR> DATA "GEOM
from counties"<BR> CLASS<BR> NAME
'county'<BR> COLOR 220 224 230<BR>
OUTLINECOLOR 0 0 0<BR> END<BR> END</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>where I have counties table with a column geom</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>very anxious!</FONT></DIV>
<DIV><FONT size=2>Regards</FONT></DIV>
<DIV><FONT size=2>Nida.</FONT></DIV>
<DIV><FONT size=2></FONT> </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><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></BLOCKQUOTE></BODY></HTML>