ORA-54530 Invalid Etype For Element At Element Offset 3D Geometry With Arcs (Doc ID 1641672.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial and Graph - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

The following query returns invalid
It is a geometry *Multiline with curves* (Multicurve) and it should be valid

SELECT SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT (
MDSYS.SDO_GEOMETRY(
3006 -- 3 Dim. 06=Multiline/Multicurve
,NULL
,NULL
,MDSYS.SDO_ELEM_INFO_ARRAY(1,2,2 ,10,2,2 )
,MDSYS.SDO_ORDINATE_ARRAY(
308222.608 , 5719510.6771 , 16.03
,308222.1079 , 5719511.17699999 , 16.03
,308221.608 , 5719510.6769 , 16.03
,308221.608 , 5719510.6769 , 16.03
,308222.1081 , 5719510.17700001 , 16.03
,308222.608 , 5719510.6771 , 16.03
)
), 0.000005) FROM DUAL;

SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT(MDSYS.SDO_GEOMETRY(3006--3DIM.06=MULTILI
--------------------------------------------------------------------------------
54530 Point:0,Edge:0,Ring:0,Polygon:0,Comp-Surf:0,Solid:0,Multi:1,

ORA-54530 invalid etype for element at element offset
Cause: Correct the etype of the geometry.
Action: An invalid etype was encountered.


Changing to *Multiline with straight lines* it is valid:

SELECT SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT (
MDSYS.SDO_GEOMETRY(
3006 -- 3 Dim. 06=Multiline/Multicurve
,NULL
,NULL
,MDSYS.SDO_ELEM_INFO_ARRAY(1,2,1 ,10,2,1 )
,MDSYS.SDO_ORDINATE_ARRAY(
308222.608 , 5719510.6771 , 16.03
,308222.1079 , 5719511.17699999 , 16.03
,308221.608 , 5719510.6769 , 16.03
,308221.608 , 5719510.6769 , 16.03
,308222.1081 , 5719510.17700001 , 16.03
,308222.608 , 5719510.6771 , 16.03
)
), 0.000005) FROM DUAL;

SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT(MDSYS.SDO_GEOMETRY(3006--3DIM.06=MULTILI
--------------------------------------------------------------------------------
TRUE


Changing to 2D it is valid

SELECT SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT (
MDSYS.SDO_GEOMETRY(
2006 -- 2 Dim. 06=Multiline/Multicurve
,NULL
,NULL
,MDSYS.SDO_ELEM_INFO_ARRAY(1,2,2 ,7,2,2 )
,MDSYS.SDO_ORDINATE_ARRAY(
308222.608 , 5719510.6771
,308222.1079 , 5719511.17699999
,308221.608 , 5719510.6769
,308221.608 , 5719510.6769
,308222.1081 , 5719510.17700001
,308222.608 , 5719510.6771
)
), 0.000005) FROM DUAL;

SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT(MDSYS.SDO_GEOMETRY(2006--2DIM.06=MULTILI
--------------------------------------------------------------------------------
TRUE

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms