OS: Windows XP
<br>Oracle Version: 9i
<br>Webserver: Apache from ms4w distribution
<br>
<br>I am not able to successfully configure oraclespatial in mapserver and was wondering if someone could help me out.
<br>
<br>First, I am using Oracle Locator -- not Oracle Spatial. Oracle Locator comes standard in Oracle, but Oracle Spatial is an extension that has to be purchased separately from Oracle. I am assuming the Oracle Locator is sufficient -- correct?
<br>
<br>I am using the Oracle Spatial example that Oracle provides on their web site: otn.oracle.com/products/oracle9i/pdf/OracleSpatial.pdf.
<br>
<br>Geometry is enclosed in a table called 'cola_markets'
<br>
<br>Next, I downloaded the ms4w package and got that running. After that, I downloaded the hobu distribution and replaced the
<br>C:\ms4w\Apache\cgi-bin directory with the contents from hobu. This should give me the capability to hookup to OracleSpatial and render data. However, all I can generate is a blank image.
<br>
<br>Questions:
<br>1) Can someone point me to what I need to get my data to render
<br>2) Is there a way to trace the code; i.e. generate debug statements in a log file
<br>3) Is there anyone who can give me a simple example, including the sql scripts to create necessary schema objects, the associated map file, and
<br>the associated PHP file.
<br>
<br>This is my current MAP file:
<br>
<br> NAME DEMO
<br>
<br> DEBUG ON
<br>
<br> STATUS ON
<br> SIZE 400 300
<br> SYMBOLSET ../etc/symbols.sym
<br> UNITS dd
<br> SHAPEPATH "../data"
<br> IMAGECOLOR 255 255 255
<br> FONTSET ../etc/fonts.txt
<br>
<br> PROJECTION
<br> "proj=latlong"
<br> "ellps=WGS84"
<br> END
<br> EXTENT -180 -45 180 45
<br>
<br> WEB
<br> MINSCALE 2000000
<br> MAXSCALE 50000000
<br> IMAGEPATH "/ms4w/tmp/ms_tmp/"
<br> IMAGEURL "/ms_tmp/"
<br> LOG "c:/ms4w/gmap.log"
<br> END
<br>
<br> LAYER
<br> DEBUG ON
<br>
<br> PROJECTION
<br> "proj=latlong"
<br> "ellps=WGS84"
<br> END
<br>
<br> NAME "oilwells"
<br> TYPE point
<br>
<br> CONNECTIONTYPE oraclespatial
<br> CONNECTION "scott/tiger!@XXXXXXX"
<br> DATA "shape FROM cola_markets USING SRID 8307"
<br>
<br> DUMP TRUE
<br> CLASS
<br> STYLE
<br> SIZE 10
<br> COLOR 0 128 128
<br> END
<br> END
<br> END
<br>
<br> END # Map File
<br>
<br>This is my current PHP file:
<br>
<br> <?php
<br> define("MAPFILE", "c:/ms4w/apps/gmap/htdocs/test11.map");
<br> define("MODULE", "php_mapscript_44.dll");
<br> if(!extension_loaded("MapScript")) dl(MODULE);
<br> $oMap = ms_newMapObj(MAPFILE);
<br> $oMap->setsize(600, 400);
<br> $oMap->selectoutputformat("png");
<br> $oImage = $oMap->draw();
<br> header("Content-type: image/gif");
<br> $url = $oImage->saveImage("");
<br> ?>
<br><hr align="left" width="300">
Sent from the <a href="http://www.nabble.com/Mapserver---User-f1215.html">Mapserver - User</a> forum at Nabble.com:<br>
<a href="http://www.nabble.com/OracleSpatial-t834577.html#a2164331">OracleSpatial</a>