Oracle Spatial Error ORA-13373 using geodetic data

[Fernando Simon]

Hi,
    Thanks for your reply, I know this problem and I already fixed this
problem in cvs version (4.5 dev).
    I used another solution because in 10g version you don`t need to use
functions to transoform geodetic data, you can see the solution in
http://mapserver.gis.umn.edu/bugs/show_bug.cgi?id=1211
    In my tests the cvs version for maporaclespatial.c worked with 4.4.x
version without problems, you can try it and test the results.
    Thanks.

------------------------------------------------------------------------
Fernando Simon
Mapserver and Oracle Spatial developer
G10 - Laboratorio de Computacao Aplicada - Brazil
http://g10.cttmar.univali.br - UNIVALI/CTTMAR
------------------------------------------------------------------------

sc wrote:

>Hi all,
>
>I am trying to get the oracle spatial connectivity working but I am getting
>the following oracle errors:
>
>SELECT rownum, SHAPE FROM SPATIAL_NAV_ARPT A WHERE SDO_FILTER( SHAPE,
>MDSYS.SDO_GEOMETRY(2003, 8307, NULL,
>MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-11.96563,49.89
>8,3.25433,60.7694) ),'querytype=window') = 'TRUE'
>
>ERROR at line 1:
>ORA-29902: error in executing ODCIIndexStart() routine
>ORA-13373:  Element of type Extent is not supported for Geodetic data
>ORA-06512: at "MDSYS.SDO_INDEX_METHOD_9I", line 368
>ORA-06512: at line 1
>
>This is an extract of my map file:
>
>        LAYER
>                NAME "Spatial Nav"
>                TYPE POLYGON
>                STATUS ON
>                CONNECTIONTYPE oraclespatial
>                CONNECTION "user/password at mydb.world"
>                DATA "SHAPE FROM SPATIAL_NAV USING SRID 8307"
>
>                CLASS
>                        NAME "Spatial"
>                        OUTLINECOLOR 60 60 06
>                        COLOR 0 0 255
>                        SYMBOL 'circle'
>                END
>        END
>
>I have noticed that other users have experienced the same problem but I
>haven't seen any solutions, I have also seen
>reference to a change of the source code?  Could this be correct?  Code
>follows:
>
>maporaclespatial.c has the extent type hardcoded to a rectangle, so =
>there is no work around, without changing the source code.
>
>
>Try changing maporaclespatial.c from:
>
>  if (apply_window)
>    sprintf( query_str + strlen(query_str),
>        "SDO_FILTER( %s.%s, MDSYS.SDO_GEOMETRY("
>          "2003, %s, NULL,"
>          "MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),"
>          "MDSYS.SDO_ORDINATE_ARRAY(%.9g,%.9g,%.9g,%.9g) ),"
>        "'querytype=3Dwindow') =3D 'TRUE'",
>        table_name, geom_column_name, srid,
>        rect.minx, rect.miny, rect.maxx, rect.maxy );
>
>to:
>
>  if (apply_window)
>    sprintf( query_str + strlen(query_str),
>        "SDO_FILTER( %s.%s, MDSYS.SDO_GEOMETRY("
>          "2003, %s, NULL,"
>          "MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),"
>          =
>"MDSYS.SDO_ORDINATE_ARRAY(%.9g,%.9g,%.9g,%.9g,%.9g,%.9g,%.9g,%.9g,%.9g,%.=
>9g) ),"
>        "'querytype=3Dwindow') =3D 'TRUE'",
>        table_name, geom_column_name, srid,
>        rect.minx, rect.miny, rect.minx, rect.maxy, rect.maxx, =
>rect.maxy, rect.maxx, rect.miny,rect.minx, rect.miny );
>
>regards
>
>Simon
>
>--
>No virus found in this outgoing message.
>Checked by AVG Anti-Virus.
>Version: 7.0.308 / Virus Database: 266.9.16 - Release Date: 18/04/2005
>
>
>