ORA-13353: ELEM_INFO_ARRAY not grouped in threes ORACLE 报错 故障修复 远程处理

文档解释

ORA-13353: ELEM_INFO_ARRAY not grouped in threes

Cause: The ELEM_INFO_ARRAY in an SDO_GEOMETRY definition has more or fewer elements than expected.

Action: Confirm that the number of elements in ELEM_INFO_ARRAY is divisible by 3.

Oracle ORA-13353错误是指数组 ELEM_INFO_ARRAY 未按三元组形式分组。一般是在处理地理图形时出现这个错误，比如使用SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT。

官方解释

ORA-13353: ELEM_INFO_ARRAY not grouped in threes

Cause: The array ELEM_INFO_ARRAY was not grouped in threes (in structured binary format) as it should have been.

Solution: Make sure that the first argument (an SDO_ELEM_INFO_ARRAY) is populated in a structured binary format i.e. as a sequence of triplets (x, y and z). Then retry the operation.

常见案例

使用SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT函数时出现这个错误。

正常处理方法及步骤

1. 检查ELEM_INFO_ARRAY是否按三元组的形式分组；

2. 检查是否有正确的数据被插入数组中；

3. 检查是否在调用SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT函数时正确传参。