utl_http.begin_request results in protocol error when url size is big
Manjit, April 23, 2018 - 2:04 pm UTC
Hi,
Thanks for the response.
Per your comment related to limit being hit at target server,
I have tried the same big URL using POSTMAN and that works fine, so I would assume there is no issue with 3rd party target server as request thru POSTMAN is successful.
Is there a limit at server from where request is being made - ex Oracle database physical server and anyway to catch/log the issue.
thanks,
April 23, 2018 - 3:07 pm UTC
I'm not aware of any limits within the database. Work with you network admins to figure out exactly what request is generated and how this travels through your network.
utl_http.begin_request results in protocol error when url size is big
Manjit, April 23, 2018 - 3:14 pm UTC
We are in touch with network admin as one tool works fine from PC while its only Oracle server that is causing this issue, tried a curl command from Oracle server with big url and that too results in issue while curl with smaller size url works fine.
Thanks a lot for looking into this request and responding.
there is a bug (24848928) in 12.1.0.2 that causes HTTP Protocolerror
A reader, March 15, 2019 - 5:25 pm UTC
Please add bug details and how we can fix.
ORA-29263: HTTP protocol error
ORA-06512: at "SYS.UTL_HTTP", line 1718
ORA-06512: at line 1
29263. 00000 - "HTTP protocol error"
*Cause: A HTTP protocol error occured during the HTTP operation.
*Action: Check the HTTP server that the HTTP operation was performed to
make sure that it follows the HTTP protocol standard.
March 18, 2019 - 10:01 am UTC
There are patches available, and fixed in 12.2