REST API data to staging table
Hi,
I am able to GET the response from REST API call using the below code
declare
v_response clob;
v_buffer varchar2(32767);
v_buffer_size number := 32000;
v_offset number := 1;
begin
-- Set connection and invoke REST API.
v_response := apex_web_service.make_rest_request(
p_http_method => 'GET',
p_username => '****@gmail.com',
p_password => '[email protected]'
--p_body => '{"LookupType":"BLOOD_TYPE"}'
);
-- Get response.
begin
loop
dbms_lob.read(v_response, v_buffer_size, v_offset, v_buffer);
-- Do something with buffer.
1