[mapserver-users] Blank image generated from oracle spatial l ayer.

[Brian McKenzie]

Hello 
I seem to be experiancing the same problems. I know this is not a
Mapserver issue, now. But since the thread was started here I thought
maybe I could get some further insight.
I upload my data to Oracle with MapInfo Easy loader. And everything
seems fine with Mapinfo, It shows up in Spatial advisor alright.

My Stuff:

Map Info Easy Loader 6.7
Oracle 8.1.7.0.1
Mapserver3.5

#
# Start of map file
#
NAME DEMO
STATUS ON
SIZE 600 600
# EXTENT 388107.634400379 5203120.88405952 500896.339019834
5310243.3061389
EXTENT -180 -90 180 90
UNITS METERS
IMAGECOLOR 255 255 255

#
# Start of web interface definition
#
WEB
  HEADER demo_header.html
  TEMPLATE demo.html
  FOOTER demo_footer.html
  MINSCALE 1000
  MAXSCALE 1550000
  IMAGEPATH "/uO1/Apache/Apache/htdocs/tmp/"
  IMAGEURL "/tmp/"
  LOG "demo.log"
END

#
# Start of layer definitions
#
LAYER
  NAME "SGIS"
  TYPE POLYGON
  STATUS ON
  CONNECTIONTYPE oraclespatial
  CONNECTION "mdsys/mdsys at lakeland.scicl.net"
  DATA "GEOLOC from cnybndpl"
  
END
END
END #Map File
<------------------>

I get this in mapserver3.5
<------------------>

msOracleSpatialLayerWhichShapes(): OracleSpatial error. ORA-29902: error
in executing ODCIIndexStart() routine ORA-13208: internal error while
evaluating [window SRID does not match layer SRID] operator ORA-06512:
at "MDSYS.SDO_INDEX_METHOD", line 84 ORA-06512: at line 1 . SQL
statement: SELECT rownum, GEOLOC FROM cnybndpl WHERE SDO_FILTER( GEOLOC,
MDSYS.SDO_GEOMETRY(2003, NULL,
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-180.3
,-179.7,179.7,180.3) ),'querytype=window') = 'TRUE' 
<------------------->

If I run the same query in SQL*PLUS i get the same error messages. From
all I heve read this would indicate some type of index problem. But
ORA-13208 error seems to indicate an SRID problem. If someone could shed
some light on this for me & point me in the direction I sure would
appreciate it. I have been head bashing for 2 days now ;(

Thanks Again 
Brian McKenzie
Stallings Crop Insurance Corp.
brian at stallingscrop.com