[Mapserver-users] ORA-13373 with 9i

Wed Mar 26 05:02:13 PST 2003

This is a multi-part message in MIME format.

------=_NextPart_000_0094_01C2F36E.024C4460
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hello,
I am trying to access some data stored in the oracle spatial ( =
SDO_GEOMETRY ) type.  When I try to draw a subset of the layer using the =
following DATA syntax:
  DATA "GEOM from tracts1test USING SRID 8307"

 I get the following error.

msOracleSpatialLayerWhichShapes(): OracleSpatial error. 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 232 ORA-06512: at line 1 . SQL =
statement: SELECT rownum, GEOM FROM tracts1test WHERE SDO_FILTER( =
tracts1test.GEOM, MDSYS.SDO_GEOMETRY(2003, 8307, =
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-71.914=
27,41.237,-68.08573,45.07) ),'querytype=3Dwindow') =3D 'TRUE'=20

Important part:
ORA-13373: Element of type Extent is not supported for Geodetic data.

When I try the query on the sqlplus command line, I get the same error.
Oracle suggests changing the query such that I use a polygon with four =
vertices instead of the rectangle spatial object type.  When I change =
the query to this it works.

SELECT rownum, GEOM FROM tracts1test=20
WHERE SDO_FILTER( tracts1test.GEOM,=20
mdsys.sdo_geometry(2003,8307,NULL,
mdsys.sdo_elem_info_array(1,1003,1),
mdsys.sdo_ordinate_array(-71.91,41.23,
-71.91,45.07,-68.08,45.07,
-68.08,41.23,-71.91,41.23) ),
'querytype=3Dwindow') =3D 'TRUE'=20

I found I could get around the error using:
  DATA "GEOM from (select GEOM from  tracts1test)"

but without the index it is very slow.

Has anyone else seen this?  What is the workaround?
Thank you for any insight,thoughts or advice.
Shannon

Linux RedHat 7.2
Mapserver 3.6
Oracle 9.0.1
Apache CGI/PHP.

------=_NextPart_000_0094_01C2F36E.024C4460
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2719.2200" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hello,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I am trying to access some data stored =
in the=20
oracle spatial ( SDO_GEOMETRY ) type.  When I try to draw a subset =
of the=20
layer using the following DATA syntax:</FONT><FONT face=3DArial=20
size=3D2></FONT></DIV>
<DIV><FONT face=3DArial size=3D2>  DATA "GEOM from tracts1test =
USING SRID=20
8307"</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2> I get the following =
error.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV>msOracleSpatialLayerWhichShapes(): OracleSpatial error. ORA-29902: =
error in=20
executing ODCIIndexStart() routine ORA-13373: Element of type Extent is =
not=20
supported for Geodetic data ORA-06512: at "MDSYS.SDO_INDEX_METHOD_9I", =
line 232=20
ORA-06512: at line 1 . SQL statement: SELECT rownum, GEOM FROM =
tracts1test WHERE=20
SDO_FILTER( tracts1test.GEOM, MDSYS.SDO_GEOMETRY(2003, 8307,=20
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-71.914=
27,41.237,-68.08573,45.07)=20
),'querytype=3Dwindow') =3D 'TRUE' </DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Important part:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2><FONT face=3D"Times New Roman" =
size=3D3>ORA-13373:=20
Element of type Extent is not supported for Geodetic =
data.</FONT></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><FONT face=3D"Times New Roman"=20
size=3D3></FONT></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><FONT face=3D"Times New Roman" =
size=3D3>When I try the=20
query on the sqlplus command line, I get the same =
error.</FONT></FONT></DIV>
<DIV>Oracle suggests changing the query such that I use a polygon with =
four=20
vertices instead of the rectangle spatial object type.  When I =
change the=20
query to this it works.</DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>SELECT rownum, GEOM FROM tracts1test =
<BR>WHERE=20
SDO_FILTER( tracts1test.GEOM,=20
<BR>mdsys.sdo_geometry(2003,8307,NULL,<BR>mdsys.sdo_elem_info_array(1,100=
3,1),<BR>mdsys.sdo_ordinate_array(-71.91,41.23,<BR>-71.91,45.07,-68.08,45=
.07,<BR>-68.08,41.23,-71.91,41.23)=20
),<BR>'querytype=3Dwindow') =3D 'TRUE' </FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I found I could get around the error=20
using:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>
<DIV><FONT face=3DArial size=3D2>  DATA "GEOM from (select GEOM =
from=20
 tracts1test)"</FONT></DIV></FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>but without the index it is very =
slow.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Has anyone else seen this?  What =
is the=20
workaround?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Thank you for any insight,thoughts or=20
advice.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Shannon</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Linux RedHat 7.2</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Mapserver 3.6</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Oracle 9.0.1</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Apache CGI/PHP.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial><BR><FONT =
size=3D2></FONT></FONT></DIV></BODY></HTML>

------=_NextPart_000_0094_01C2F36E.024C4460--