API Integrations

 

I am using Oracle PLSQL to get the current Temperature For my APEX application.. This is my code for Fetching the Data from API /* Formatted on 2020/06/12 09:04 (Formatter Plus v4.8.8) */ DECLARE req UTL_HTTP.req; resp UTL_HTTP.resp; VALUE LONG; l_obj json_object_t; request_context UTL_HTTP.request_context_key; l_dept_arr json_array_t; l_dept_obj json_object_t; l_emp_arr json_array_t; l_emp_obj json_object_t; BEGIN ---UTL_HTTP.set_wallet ('file:E:\wallets', '********'); request_context := UTL_HTTP.create_request_context (wallet_path => 'E:\******', wallet_password => '*******' ); req := UTL_HTTP.begin_request (utl_url.ESCAPE ('http://dataservice.accuweather.com/currentconditions/v1/*****?&apikey=*******...