Oracle Spatial Error ORA-13373 using geodetic data

[sc]

Hi,

the 4.5 dev version has stopped the error, thanks, now I have the issue
that none of the data is being displayed.  The SQL coming from Mapserver
is correct and records are being returned, why would the data not display
on the image?  Is my map file incorrect?

       LAYER
                NAME "Spatial Nav"
                TYPE POLYGON
                STATUS ON
                CONNECTIONTYPE oraclespatial
                CONNECTION "user/password at mydb.world"
                DATA "SHAPE FROM SPATIAL_NAV USING SRID 8307 VERSION 9i"

                CLASS
                        NAME "Spatial"
                        OUTLINECOLOR 60 60 06
                        COLOR 0 0 255
                        SYMBOL 'circle'
                END
        END

regards

Simon

-----Original Message-----
From: Fernando Simon [mailto:fsimon at univali.br]
Sent: 18 April 2005 18:49
To: sc
Cc: MAPSERVER-USERS at LISTS.UMN.EDU
Subject: Re: [UMN_MAPSERVER-USERS] Oracle Spatial Error ORA-13373 using
geodetic data


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.8
9
>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
>
>
>



--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.9.16 - Release Date: 18/04/2005

--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.9.17 - Release Date: 19/04/2005