APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

apex_web_service.make_rest_request ORA-29263 ORA-06512 ORA-29273

tfaOct 17 2019 — edited Oct 17 2019

When using apex_web_service.make_rest_request to call a web service that takes more than 4 minutes to return data it fails at 180 seconds (3 minutes). Same web service can be successfully called from browser and Postman tool.

ORA-29273: HTTP request failed

ORA-06512: at "SYS.UTL_HTTP", line 1367

ORA-29263: HTTP protocol error

ORA-06512: at "SYS.UTL_HTTP", line 1367

ORA-06512: at "APEX_180200.WWV_FLOW_WEB_SERVICES", line 1017

ORA-06512: at "APEX_180200.WWV_FLOW_WEB_SERVICES", line 1523

ORA-06512: at "APEX_180200.WWV_FLOW_WEBSERVICES_API", line 369

ORA-06512: at line 35

In this environment we also have other web services that are being successfully called via apex_web_service.make_rest_request on same remote host.

I'm thinking issue is a timeout setting that's being encountered but don't know where to look.

Another thought is data size limitations, but the data is not real large. A successful call via Postman shows data size is 675.02KB and web service response took 3m 42s.

Thoughts?

APEX version 18.2.0.00.12

ORDS version 18.4.0.r3541002

Database version 11.2.0.4.0

Regards,

Todd

This post has been answered by Pierre Yotti on Oct 17 2019

Jump to Answer

Added on Oct 17 2019

#apex-discussions

2 comments

911 views