I'm trying to call a SOAP request with the Web Service process of Oracle Apex.
The code is working and I have all the data needed on screen but sometimes it call an unhandled exception:
Error: ORA-29273: HTTP Request failed
- Additional info:
- Display location: INLINE_IN_NOTIFICATION
- Association type:
- Item name:
- Region id:
- Column alias:
- Row:
- Model instance id:
- Model record id:
- Internal error: false
- Common runtime error: false
- APEX error code:
- SQL code: -29273
- SQL error: ORA-29273: HTTP Request failed
ORA-06512: a "APEX_230100.WWV_FLOW_WEB_SERVICES", line 1818
ORA-06512: a "APEX_230100.WWV_FLOW_WEB_SERVICES", line 1473
ORA-29263: errore nel protocollo HTTP ORA-06512: a "SYS.UTL_HTTP", line 837
ORA-06512: a "SYS.UTL_HTTP", line 1350
ORA-06512: a "APEX_230100.WWV_FLOW_WEB_SERVICES", line 1467
ORA-06512: a "APEX_230100.WWV_FLOW_WEB_SERVICES", line 1487
ORA-06512: a "APEX_230100.WWV_FLOW_WEB_SERVICES", line 1785
ORA-06512: a "APEX_230100.WWV_FLOW_WEB_SERVICES", line 1840
ORA-06512: a "APEX_230100.WWV_FLOW_WEBSERVICES_API", line 365
ORA-06512: a "APEX_230100.WWV_FLOW_WEBSERVICES_API", line 406
- Backtrace: ORA-06512: a "APEX_230100.WWV_FLOW_WEB_SERVICES", line 1818
ORA-06512: a "APEX_230100.WWV_FLOW_WEB_SERVICES", line 1473
ORA-06512: a "SYS.UTL_HTTP", line 837
ORA-06512: a "SYS.UTL_HTTP", line 1350
ORA-06512: a "APEX_230100.WWV_FLOW_WEB_SERVICES", line 1467
ORA-06512: a "APEX_230100.WWV_FLOW_WEB_SERVICES", line 1487
ORA-06512: a "APEX_230100.WWV_FLOW_WEB_SERVICES", line 1785
ORA-06512: a "APEX_230100.WWV_FLOW_WEB_SERVICES", line 1840
ORA-06512: a "APEX_230100.WWV_FLOW_WEBSERVICES_API", line 365
ORA-06512: a "APEX_230100.WWV_FLOW_WEBSERVICES_API", line 406
ORA-06512: a line 37 - Statement: - Component: APEX_APPLICATION_PAGE_DA_ACTS NATIVE_EXECUTE_PLSQL_CODE (55022850849839076)
I tried to call it with UTL_HTTP.MAKE_REQUEST but in the ending the error is called anyway.
I tried to debug it but nothing, the file requested is a CLOB and 3 times on 4 is working!