oracle spatial connection

[Fernando Simon]

Hi all,
    This error can be relate with Oracle Spatial directly. After you 
imported your data in database did you execute the 
SDO_MIGRATE.TO_CURRENT function?
    This step is important to fix some objects in database. As Jukka 
wrote, you need to check the projection did you define, can you try to 
draw a map without any projection defined?.
    Best regards.

---------------------------------------------------
Fernando Simon
UMN Mapserver and Oracle Spatial developer

Rahkonen Jukka wrote:
> 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: MAPSERVER-USERS at LISTS.UMN.EDU
> 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/bigmaps at orcl"
>   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
>
>