Hi all,
I am currently working with Application Express 20.1.0.00.13
I am using the following instruction to call a third party web service and it seems that the p_transfer_timeout=> 60 does not wait before continuing process even if response is still not received from the third party application.
Refreshing the page a few times will eventually show the correct response but I was expecting the "p_transfer_timeout=> 60" to wait for the response before giving control back to the user again.
So in essence the execution "appears" to leave the PL/SQL script, give control back to the user and then execute the remaining code in the PL/SQL script. Refreshing the page manually eventually updates the STATUS and different page items that show successful/fail process.
I tried putting an alert in a javascript code following the pl/sql but it does not appear to go through it.
l_response := apex_web_service.make_rest_request(p_url => v_url, p_http_method => 'POST', P_body => v_body, p_transfer_timeout=> 60);
Is there something I am not getting here?<
As always, any suggestions, tips, comments are greatly appreciated.
Thanks,
Jake