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

20220601 - 스피너 spinner 보이기/감추기

1. dynamic action for JavaScript

  //execute spinner

  var spinner = apex.util.showSpinner();

2. dynamic action for plsql code

  your plsql code

    

3. dynamic action for JavaScript

  //remove spinner

  $("#apex_wait_overlay").remove();

  $(".u-Processing").remove();

참고

https://parthiban037.wordpress.com/2020/01/03/show-spinner-in-oracle-apex-dynamic-action/