Client Plugin (plsql.js) #4

by Plurimedia

JavaScript

create or replace package body mypackage as
.
.
.

   procedure read(p_pars in varchar2,
                  p_out  in out nocopy clob) is

      V_jsonl pljson_list := pljson_list();
      v_json  pljson := pljson(p_pars);

   begin

      for item in (select * from mytable) loop

         v_json := pljson();
         v_json.put('_id', item.id);
         v_json.put('descrizione', item.descrizione);
         v_json.put('codice', item.codice);

         v_jsonl.append(v_json);

      end loop;

      v_jsonl.to_clob(p_out);

   end read;
.
.
.
end mypackage;
/