I want to read the value of P_PROCESS_FLAG in the given example below. The below code is not returning the value 'S'. How do I read the value of P_PROCESS_FLAG in the example below
declare
l_output varchar2(4000);
l_obj json_object_t;
l_process_flag varchar2(100);
begin
l_output := '{
"OutputParameters" : {
"@xmlns" : "http://xmlns.oracle.com/apps/per/rest/HR_EMP_SYNC_GLB/create_employee/",
"@xmlns:xsi" : "http://www.w3.org/2001/XMLSchema-instance",
"P_PROCESS_FLAG" : "S",
"P_ERROR_MESSAGE" : null
}
}';
l_obj := json_object_t.parse (l_output);
l_process_flag := l_obj.get_string('OutputParameters.P_PROCESS_FLAG');
dbms_output.put_line('l_process_flag is '||l_process_flag);
exception
when others then
dbms_output.put_line('SQLERRM '||sqlerrm);
end;