Hi ,
Can any one provide a sample code on how to convert the json data in tabular format and insert to Oracle apex collections. From the below code I get the response those response I have attached it .That response I want to insert into Oracle apex collections instead of creating a temp table.
The apex version is 19.2.0.00.18
Thanks in advance
declare
L_QUERY :=q'[
select empno,ename from EMP ]';
APEX_WEB_SERVICE.G_REQUEST_HEADERS (1).NAME := 'Content-Type';
APEX_WEB_SERVICE.G_REQUEST_HEADERS (1).VALUE := 'application/sql';
L_RESPONSE :=
APEX_WEB_SERVICE.MAKE_REST_REQUEST (
P_URL => LV_REST_URL,
P_HTTP_METHOD => 'POST',
P_SCHEME => 'OAUTH_CLIENT_CRED',
P_BODY => L_QUERY);
END;