20220601 - APEX JSON을 활용한 AJAX Return

1. PL/SQL with cursor

DECLARE

  l_cursor SYS_REFCURSOR;

BEGIN

  OPEN l_cursor FOR

    select po_mst.cust_nm

         , po_mst.cust_addr

         , po_mst.delivery_req

         , po_mst.memo

      from po_mst

     where rownum <= 2;

  APEX_JSON.initialize_clob_output;

  APEX_JSON.open_object;

  APEX_JSON.write('targetlist', l_cursor);

  APEX_JSON.close_object;

  DBMS_OUTPUT.put_line(APEX_JSON.get_clob_output);

  APEX_JSON.free_output;

END;

2. 결과

{
"targetlist":[
{
"CUST_NM":"OOOO"
,"CUST_ADDR":"주소는 XXXX"
,"DELIVERY_REQ":"감사합니다"
}
,{
"CUST_NM":"OOO"
,"CUST_ADDR":"주소는 OOOOO"
,"DELIVERY_REQ":"네. 감사합니다."
}
]
}

참고

https://oracle-base.com/articles/misc/apex_json-package-generate-and-parse-json-documents-in-oracle