PL/SQL (MOSC)

MOSC Banner

Parse json output in PLSQL

edited Feb 25, 2020 4:34AM in PL/SQL (MOSC) 5 commentsAnswered ✓

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center