rest_on_oracle

rest_on_oracle.sql

declare
   l_url            varchar2(100) := 'http://datamaker-stage.aoa.inbcu.com/data-maker/health';
   l_req            utl_http.req;
   l_result         utl_http.resp;
   l_data           varchar2(4000);
   l_clob           clob;
 begin
   dbms_lob.createtemporary(l_clob,true);
   l_req  := utl_http.begin_request(l_url);
   l_result := utl_http.get_response(l_req);
 
   begin
     loop
       utl_http.read_text(l_result, l_data, 2000);
       dbms_lob.writeappend(l_clob,length(l_data),l_data);
       dbms_output.put_line (l_data);
     end loop;
   exception
   when utl_http.end_of_body then
    utl_http.end_response(l_result);
   end;

 insert into data_maker.lake_config values (sys_guid(), l_clob);
 commit;
 dbms_lob.freetemporary(l_clob);
 end;
 
 
 
create table lake_config
(id VARCHAR2(32),
 json_doc CLOB
 CONSTRAINT ensure_json CHECK (json_doc is JSON)
 );