DECLARE
l_json_str VARCHAR2(4000);
l_json json;
l_year VARCHAR2(10);
l_month VARCHAR2(10);
TYPE arrays_data_rec IS RECORD(
id NUMBER
,code VARCHAR2(30)
,NAME VARCHAR2(100));
TYPE arrays_data_tab IS TABLE OF arrays_data_rec INDEX BY BINARY_INTEGER;
l_arrays_tab arrays_data_tab;
l_bodylist json_list; --json列表
l_arrays_json json; --用于解析每一个数组信息
BEGIN
l_arrays_tab.delete;
l_json_str := '{
"year": "2019",
"month":"05",
"strArray": [{
"id": 1,
"code": "CODE1",
"name": "NAME1"
},{
"id": 2,
"code": "CODE2",
"name": "NAME2"
},{
"id": 3,