Parse json output in PLSQL
I am running a PLSQL block which generates json output. It is a http call to a url using below code:
DECLARE
l_http_request UTL_HTTP.req;
l_http_response UTL_HTTP.resp;
l_text VARCHAR2(32767);
BEGIN
-- Make a HTTP request and get the response.
l_http_request := UTL_HTTP.begin_request(url);
-- Use basic authentication if required.
--IF p_username IS NOT NULL and p_password IS NOT NULL THEN
UTL_HTTP.set_authentication(l_http_request, username, pwd);
--END IF;
l_http_response := UTL_HTTP.get_response(l_http_request);
-- Loop through the response.