ORA-54530 Invalid Etype For Element At Element Offset (Doc ID 1446335.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial - Version: 11.2.0.3 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Symptoms

3D Compound lines are valid in 10.2 but they are invalid in 11.2.0.3

Example:

SDO_GEOMETRY(3002, NULL, NULL, SDO_ELEM_INFO_ARRAY(
1, 4, 15,
1, 2, 1,
4, 2, 2,
10, 2, 1,
13, 2, 2,
19, 2, 1,
22, 2, 2,
28, 2, 1,
31, 2, 2,
37, 2, 1,
40, 2, 2,
46, 2, 1,
49, 2, 2,
55, 2, 1,
58, 2, 2,
64, 2, 1),
SDO_ORDINATE_ARRAY(
2520227.38, 2409490.49, 0,
2520224.66, 2409486.11, 0,
2520224.41, 2409485.92, 0,
2520224.11, 2409485.99, 0,
2520221.84, 2409487.25, 0,
2520221.38, 2409487.38, 0,
2520221.01, 2409487.08, 0,
2520218.2, 2409482.49, 0,
2520217.97, 2409482.26, 0,
2520217.66, 2409482.35, 0,
2520215.46, 2409483.7, 0,
2520214.85, 2409483.72, 0,
2520214.39, 2409483.32, 0,
2520211.74, 2409478.99, 0,
2520211.51, 2409478.73, 0,
2520211.18, 2409478.83, 0,
2520210.18, 2409479.37, 0,
2520209.2, 2409479.38, 0,
2520208.27, 2409479.06, 0,
2520192.1, 2409470.26, 0,
2520188.43, 2409468.34, 0,
2520184.59, 2409466.79, 0,
2520179.1, 2409464.9, 0))

This was valid in 10.2 and it is invalid now in 11.2.0.3

ORA-54530 invalid etype for element at element offset

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