i want to load json file with map data to apex using a file browsr item but i keep on getting this error
ora_sqlerrm: ORA-20987: Error at line 1, col 1: expected [ or { 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 "APEX_220200.WWV_FLOW_JSON", line 1320 ORA-06512: at "APEX_220200.WWV_FLOW_JSON", line 560 ORA-06512: at "APEX_220200.WWV_FLOW_JSON", line 1311 ORA-06512: at "APEX_220200.WWV_FLOW_JSON", line 1337 ORA-06512: at "APEX_220200.WWV_FLOW_JSON", line 1350 ORA-06512: at line 4 ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120 ORA-06512: at
this is my procedure and table
CREATE TABLE json_data (
id VARCHAR2(100),
label VARCHAR2(100),
color VARCHAR2(50),
polygon SDO_GEOMETRY
);
CREATE OR REPLACE PROCEDURE load_json_data(json_data CLOB) IS
v_id VARCHAR2(100);
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[0]') || ',' || JSON_VALUE(json_data, '$.data.color[1]') || ',' || JSON_VALUE(json_data, '$.data.color[2]') INTO v_color FROM DUAL;
SELECT JSON_VALUE(json_data,'$.data.allData[0][0].geometry' RETURNING SDO_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;