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

[Rodrigo Becke Cabral]

Hello Debasish,

I'll try to answer all of your questions with one single e-mail.

----- Original Message -----
Sent: Wednesday, June 20, 2001 6:41 AM
> Am working on NT with Mapserver 3.5 . The problem is mapserver is
> generating a blank white image for the oracle spatial layer.
> Am i missing out something. The description of map file is as follows
>
> LAYER
>   NAME states
>   TYPE polygon
>   STATUS default
>   CONNECTIONTYPE oraclespatial
>   CONNECTION 'system/manager at orcl'
>   DATA "GEOM from country"
>   CLASS
>     NAME 'states'
>     COLOR 220 224 230
>     OUTLINECOLOR 0 0 0
>   END
> END

Looks like your map definition is okay, and MapServer is drawing everything
according to your definitions. So I guess your data is not showing up
because it's not within the extents you supplied (EXTENT -180 -90 180 90).
If they're in UTM, this is mostly like the case. You can use SDO functions
to query your data extents and be sure of what you have.

----- Original Message -----
Sent: Wednesday, June 20, 2001 4:05 AM
> I am getting the following error when i try to load an oracle spatial
> layer. 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 states WHERE SDO_FILTER( GEOLOC,
> MDSYS.SDO_GEOMETRY(2003, NULL,
> NULL,MDSYS.SDO_ELEM_INFO_ARRAY
> (1,1003,3),MDSYS.SDO_ORDINATE_ARRAY
> (-228.293276,-60.0032762,-16.6267238,151.663276) ),'querytype=window')
> = 'TRUE'

Here's certainly an SDO indexing/srid problem, not related to MapServer.
Have you created the spatial indexes at all? Try running the following
command using your SQL command prompt (then you may track the error):

SELECT rownum, GEOLOC FROM states WHERE SDO_FILTER( GEOLOC,
MDSYS.SDO_GEOMETRY(2003, NULL, NULL,MDSYS.SDO_ELEM_INFO_ARRAY
(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY
(-228.293276,-60.0032762,-16.6267238,151.663276) ),'querytype=window') =
'TRUE'

----- Original Message -----
Sent: Wednesday, June 20, 2001 2:47 AM
> I tried using the oracle spatial option in the mapserver ver 3.5
> makefile.vc but not yet succesful . Can you please show an example .
>
> #oracle spatial
> ORACLESPATIAL_OPT=-DUSE_ORACLESPATIAL
> ORACLESPATIAL_INC=-I./oci/include

As I mentioned, I haven't tested or worked with an VC compiler to make sure
everything is running accordingly. Also, looks like the ORACLESPATIAL_INC
variable is missing it's home path in the -I part. But I guess, based on
your other questions, you solved this problem. If this is the case, perhaps
you could share with this list how you manage to make things working with
Oracle Spatial on an NT environment.

Best regards,
Rod.