JSON - PL/SQL ORA-30625:不允许对NULL自身参数执行方法调度

Question

示例JSON：

[
  {
    "term-id": "BA000000",
    "bank-id": "111",
    "location": "Poslovalnica banke",
    "address": "Cankarjeva ulica 2",
    "city": "Ljubljana",
    "post-code": "1000",
    "printer": "true",
    "deposit": "false",
    "accessible": "true",
    "cards": "DECPVR",
    "special-payments": "false",
    "BNA": "false",
    "transaction-receipt": "true",
    "latitude": 46.051671,
    "longitude": 14.505122
  }
]

我正在尝试使用pljson：

declare
  w_req t_http_request := t_http_request();
  w_res t_http_response;
  w_vrni clob;
  w_json pljson;
  w_jsonValue pljson_value;
  w_jsonList pljson_list;
  w_test varchar2(100);
begin
  w_req.url := 'https://api.bankart.si/psd2/hub/v1/' || 'ATMList';
  w_req.add_header('x-ibm-client-id', 'client-id');
  w_res := https_client.doGet (w_req, 'DB');
  w_vrni := hibis_util.convertBlobToClob(w_res.content_blob,'AL32UTF8');
  
  w_jsonList := pljson_list(w_vrni);
  if w_jsonList is not null and w_jsonList.count > 0 then
    for i in 1..w_jsonList.count loop
      w_json := pljson(w_jsonList.get(i));
      w_jsonValue := w_json.get('term-id');
      w_test := w_jsonValue.get_string;
      dopl(w_test);
    end loop;
  end if;
end;

我可以从这个JSON中提取位置或地址值，但当我想要提取元素term-id或bank-id时，我得到错误PL/SQL ORA-30625:不允许对NULL SELF参数执行方法调度。也许是因为"-“符号之间的关系？

有谁有什么想法吗？谢谢。

Answer 1

我觉得你把事情搞得太复杂了。:)尝试：

set serveroutput on
declare
   v_json pljson;
   v_test varchar2(100);
   v_jsonl pljson_list := pljson_list('[
  {
    "term-id": "BA000000",
    "bank-id": "111",
    "location": "Poslovalnica banke",
    "address": "Cankarjeva ulica 2",
    "city": "Ljubljana",
    "post-code": "1000",
    "printer": "true",
    "deposit": "false",
    "accessible": "true",
    "cards": "DECPVR",
    "special-payments": "false",
    "BNA": "false",
    "transaction-receipt": "true",
    "latitude": 46.051671,
    "longitude": 14.505122
  }
]');
begin
   for i in 1..v_jsonl.count loop
      v_json := pljson(v_jsonl.get(i));
      v_test := v_json.get('term-id').get_string;
      dbms_output.put_line(v_test);
   end loop;
end;