Hi, I would check first if the extents of the map file and data returned from Oracle match. Oracle used to have only its own SRID system (nothing to do with epsg codes) before 10g version. Make a simple SQL request directly with SQL*Plus for one feature only and check if the coordinates you get really fall inside your map extents.
-Jukka Rahkonen- -----Original Message----- From: UMN MapServer Users List on behalf of Gagan Bansal Sent: Sat 15.9.2007 12:51 To: [email protected] Subject: [UMN_MAPSERVER-USERS] oracle spatial connection i am trying to dispaly the oracle spatial 10g v2 data in mapserver but my application display the blank page, not able to get where is the mistake following has been done: # -load shape file in oracle using shp2sdojava - created spatial index on 'geom' # swapping dll as described in the readme file of the mapserver #Setting environment variables - ORACLE_HOME : C:\oracle\product\10.2.0\db_1 - ORACLE_SID : orcl - TNS_ADMIN : C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN #here is the map file for oracle spatial data connection MAP NAME DEMO STATUS ON SIZE 400 300 SYMBOLSET ../etc/symbols.sym EXTENT -1001942.225269 2155071.744446 -998438.476117 2158497.456450 UNITS METERS SHAPEPATH "../data1" IMAGECOLOR 255 255 255 FONTSET ../etc/fonts.txt TRANSPARENT FALSE # Start of web interface definition WEB IMAGEPATH "/ms4w/tmp/ms_tmp/" IMAGEURL "/ms_tmp/" LOG "/tmp/bigmaps_oracle.log" MS_ERRORFILE "/tmp/bigmaps_oracle_error.log" METADATA END END # Start of reference map PROJECTION "init=epsg:32643" END # Start of layer definitions LAYER GROUP "Polygon" NAME playground CONECTIONTYPE oraclespatial CONNECTION "scott/[EMAIL PROTECTED]" DATA "GEOM FROM PLAYGROUND_UTM USING UNIQUE OBJECTID USING SRID 32643" METADATA "DESCRIPTION" "playground" "RESULT_FIELDS" "OBJECTID" "GROUP" "Polygon" "LAYER" "playground" END TYPE POLYGON STATUS ON CLASS NAME "playground" COLOR 200 255 0 OUTLINECOLOR 120 120 120 END TOLERANCE 5 END # Layer END # Map File log file also not being creaed in the specified folder? Thanks of any help Gagan
