Oracle Spatial Error ORA-13373 using geodetic data

[Fernando Simon]

Hi again,
   This way is the correct way to permorf the query's with geodetic
data. I used this way to solve the problem in maporaclespatial.c.
   But for the 10G version you don't need to use this function because
the Spatial do the conversion on the fly, without user interaction.
   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 all,
>
>I have some more information on this problem, if I rewrite the SELECT
>statement produced by mapserver to use the sdo_cs.viewport_transform()
>function as shown below then the SELECT works ok, is this a problem with
>mapserver
>or am I doing something wrong?
>
>I also noted that the sdo_ordinate array is being populated with values that
>are slighty different to my MAP files EXTENTS,
>is this an error or am I misunderstanding something?
>
>(EXTENTS -10.458000 49.898000 1.746700 60.769400)
>
>SELECT rownum, icao, SHAPE
>FROM SPATIAL_NAV
>WHERE SDO_FILTER(
>SHAPE,
>sdo_cs.viewport_transform(
>MDSYS.SDO_GEOMETRY(2003, 0, NULL,
>MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),
>MDSYS.SDO_ORDINATE_ARRAY(-11.96563,49.898,3.25433,60.7694)),
>8307),'querytype=window') = 'TRUE' ;
>
>regards
>
>Simon
>
>