ora_sqlerrm: ORA-13050: unable to construct spatial object ORA-06512: at "APEX_220200.WWV_FLOW_PROCESS_NATIVE", line 55 ORA-06512: at "APEX_220200.WWV_FLOW_CODE_EXEC_PLSQL", line 126 ORA-06512: at "APEX_220200.WWV_FLOW_DYNAMIC_EXEC", line 2654 ORA-06512: at "MDSYS.SDO_UTIL", line 673 ORA-06512: at "MDSYS.SDO_UTIL", line 691 ORA-06512: at line 1 ORA-06512: at
procedure i am using create or replace PROCEDURE load_json_data(json_data CLOB) IS
v_id NUMBER;
v_label VARCHAR2(100);
v_color VARCHAR2(20);
v_polygon SDO_GEOMETRY;
BEGIN
-- Parse the JSON data
SELECT JSON_VALUE(json_data, '$.data.id') INTO v_id FROM DUAL;
SELECT JSON_VALUE(json_data, '$.data.label') INTO v_label FROM DUAL;
SELECT JSON_VALUE(json_data, '$.data.color') INTO v_color FROM DUAL;
SELECT SDO_UTIL.FROM_JSON(
JSON_VALUE(json_data, '$.data.allData[0][0].geometry')
) INTO v_polygon FROM DUAL;
-- Insert the data into the table
INSERT INTO json_data (id, label, color, polygon)
VALUES (v_id, v_label, v_color, v_polygon);
END;