Oracle Spatial Error ORA-13373 using geodetic data

[Fernando Simon]

Hi,
    About the data problem, can be little problems.
    How did you import the data in your database? With loader? If yes,
did you execute the Oracle migrate function? To check the internal sql
you can compile the Mapserver using the DEBUG flag, if you use it the
maporaclespatial will report the internal sql that retrieve the spatial
data.
    Another problem can be with the extents, the data form the database
can be diferent of your extents, in another kind. To fix this problem
you can define a Projection for your layer to transform your data.
    Thanks for your reply.

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

sc wrote:

>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
>
>