I have a plsql package that makes API calls using the Oracle UTL_HTTP package.
Using the package has been successful for several years. But now we have upgraded to a new server using Oracle 19c. All the updating works, but several calls using Begin_Request with Method='GET' fail with error "ORA-29276: transfer timeout".
Working on the problem, I discovered removing the prefix "http://" from the URL enables the GET process to work as expected, but this causes other API calls to fail.
Could this be a certificate problem, or something else?
Edit: Login shows: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.8.0.0.0
Final Edit: Based on the answer here: utl_http request and response stops when > 32k
I was doing this: UTL_HTTP.SET_HEADER(req,'Transfer-Encoding', 'chunked' );
before this: UTL_HTTP_BEGIN_REQUEST(g_URL,'GET','HTTP/1.1');
Using the 'chunked' in the older version of Oracle was apparently ignored. Now, it causes the trouble I was having. Everything worked immediately after I commented-out the Set_Header line.