We are running some api calls that can sometimes return very large json payloads. It seems APEX_JSON cannot parse those. For example , I'm getting a count of 93 for a given path, but it seems the loop only runs once, even if I hard code a number for the loop.
...Snippet Example
apex_json.parse(l_values , resp) ;
v_count := apex_json.get_count(p_path=>'response',p_values=>l_values);
for i in 1 .. v_count loop
DBMS_OUTPUT.PUT_LINE( 1);
v_val1 := APEX_JSON.GET_VARCHAR2(p_path => 'response[%d].entity' , p_values=>l_values, p0=> i);
v_val2 := APEX_JSON.GET_VARCHAR2(p_path => 'response[%d].id' , p_values=>l_values, p0=> i);
END LOOP;
....
In the example above the loop only runs once , unless I comment out the v_val1 := ..... section which parses the Json , then it runs the total ( v_count) . V_VAL1 and V_VAL2 are just examples, there are about 20 total variables that are parsed with each loop. Is there any way around this ? We are on Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production.