Dear All
Im using APEX_WEB_SERVICE as below and im specifying the transfer_timeout parameter to some value:
l_xml := APEX_WEB_SERVICE.make_request(
p_url => 'http://10.60.60.61:8080/TCIBServiceHub/services',
p_action => 'http://10.60.60.61:8080/TCIBServiceHub/'||P_OPERATION,
p_envelope => P_PAYLOAD,
p_transfer_timeout => 10
);
when the request take more than 10 seconds oracle gives the ORA-29276: transfer timeout like below:
END;
Error at line 2
ORA-29273: HTTP request failed
ORA-06512: at "APEX_180200.WWV_FLOW_WEB_SERVICES", line 1931
ORA-06512: at "SYS.UTL_HTTP", line 1267
ORA-29276: transfer timeout
ORA-06512: at "SYS.UTL_HTTP", line 651
ORA-06512: at "SYS.UTL_HTTP", line 1257
ORA-06512: at "APEX_180200.WWV_FLOW_WEB_SERVICES", line 1905
ORA-06512: at "APEX_180200.WWV_FLOW_WEBSERVICES_API", line 157
ORA-06512: at "TNB_INTEG_SERVICE_HUB.TCIB_SOAP_REQUEST", line 12
ORA-06512: at "TNB_INTEG_SERVICE_HUB.TCIB_ESERVICES_PKG", line 153
ORA-06512: at line 5
i simply want to be able to handle the timeout error in plsql exception like
EXCEPTION WHEN UTL_HTTP.transfer_timeout
THEN
DBMS_OUTPUT.put_line ('TTTTTTTTTTTTTTTTIIIIIIIIIMMMMMMMMMMMMEEEEEEEEEEE OUT');
END;
however it didn't work like this
can anyone tell me how exactly i can handle the timeout exception for APEX_WEB_SERVICE because what i want to do is that if the timeout occur i want to handle the request in another approach so i need to know how to catch the exception in the first place.
BR