Generating JSON from Oracle Database

json.sql

declare
  l_xml xmltype;
  l_json clob;
begin 
  apex_json.initialize_clob_output;

  select XMLElement("obj",
    XMLForest(      
        XMLForest(
          12345 as "id"
        ) as "issue",
        XMLForest(
           'SOME TEMPLATE' as "name"
        ) as "template"
      ))
    into l_xml
    from dual;

  apex_json.write(l_xml);
  
  l_json := apex_json.get_clob_output;
  
  apex_json.free_output;
  
  dbms_output.put_line(l_json);
end;