Hi everyone,
I’m working with a PL/SQL package that makes multiple SOAP web service calls to an Oracle BI Publisher endpoint:
swift
CopyEdit
/xmlpserver/services/v2/ReportService?wsdl
To make these requests, I’m using apex_web_service.make_request.
Certificate Setup
I imported the certificate for this endpoint using orapki and added it to the wallet. Then I configured the wallet path via Oracle Instance Admin in APEX.
After this setup, the certificate error disappeared and the API started working.
Problem
However, I’m now facing intermittent errors. Sometimes the call succeeds, and sometimes it fails with different errors. Here are the error messages I’ve encountered:
Example 1: End-of-Input
ORA-29273: HTTP request failed
ORA-06512: at "APEX_240200.WWV_FLOW_WEB_SERVICES_INVOKER", line 1217
ORA-06512: at "APEX_240200.WWV_FLOW_WEB_SERVICES_INVOKER", line 650
ORA-29259: end-of-input reached
ORA-06512: at "SYS.UTL_HTTP", line 380
ORA-06512: at "SYS.UTL_HTTP", line 1148
ORA-06512: at "APEX_240200.WWV_FLOW_WEB_SERVICES_INVOKER", line 598
ORA-06512: at "APEX_240200.WWV_FLOW_WEB_SERVICES_INVOKER", line 1078
ORA-06512: at "APEX_240200.WWV_FLOW_WEB_SERVICES_INVOKER", line 1564
ORA-06512: at "APEX_240200.WWV_FLOW_WEB_SERVICES", line 832
ORA-06512: at "APEX_240200.WWV_FLOW_WEBSERVICES_API", line 445
Example 2: HTTP Protocol Error
ORA-29263: HTTP protocol error
ORA-06512: at "APEX_240200.WWV_FLOW_WEB_SERVICES", line 799
ORA-06512: at "APEX_240200.WWV_FLOW_WEB_SERVICES_INVOKER", line 350
ORA-06512: at "SYS.UTL_HTTP", line 797
ORA-06512: at "SYS.UTL_HTTP", line 1335
ORA-06512: at "APEX_240200.WWV_FLOW_WEB_SERVICES_INVOKER", line 344
ORA-06512: at "APEX_240200.WWV_FLOW_WEB_SERVICES_INVOKER", line 1484
ORA-06512: at "APEX_240200.WWV_FLOW_WEB_SERVICES", line 755
ORA-06512: at "APEX_240200.WWV_FLOW_WEBSERVICES_API", line 705
What I’ve Checked
- Wallet is configured and contains the certificate
- Wallet path is set in the APEX admin panel
- Calls sometimes work, so the config seems mostly correct
- Errors vary and are not consistently reproducible
Are there recommended debug steps or logging methods to trace apex_web_service.make_request failures deeper?
Any guidance would be appreciated!
Thanks in advance,
Srimathi