Oracle Spatial Error ORA-13373 using geodetic data

[sc]

Hi,

The SELECT statement produced by mapserver works ok in SQL*Plus and rows of
data are returned.
The data was NOT imported using sql*loader.

regards

Simon

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


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



--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.9.17 - Release Date: 19/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