title: Oracle Error: ORA-29273: HTTP request failed ORA-29259: end-of-input reached
body: <p>I am trying to call <a href="https://docs.oracle.com/cloud/latest/marketingcs_gs/OMCBB/" rel="nofollow noreferrer">Eloqua API</a> using <a href="https://docs.oracle.com/database/121/AEAPI/apex_web_service.htm#AEAPI537" rel="nofollow noreferrer">apex_web_service.make_rest_request()</a> from PL/SQL (using SQL Developer)</p>
  <pre><code> v_clob_body := apex_web_service.make_rest_request(
      p_url              =&gt; 'https://secure.p02.eloqua.com/API/Bulk/2.0/contacts/exports/1/data?offset=0',
      p_http_method      =&gt; 'GET',
      p_username         =&gt; null,
      p_password         =&gt; null,
      p_proxy_override   =&gt; '&lt;proxy&gt;',
      p_transfer_timeout =&gt; 6000,
      p_body             =&gt; null,
      p_body_blob        =&gt; empty_blob(),
      p_wallet_path      =&gt; '&lt;wallet_path&gt;',
      p_wallet_pwd       =&gt; '&lt;wallet_pwd&gt;');
  </code></pre>
  <p>When trying to execute the GET call, it's throwing the following exception:</p>
  <pre><code>ORA-29273: HTTP request failed
  ORA-29259: end-of-input reached
  ORA-06512: at &quot;SYS.UTL_HTTP&quot;, line 1258
  ORA-06512: at &quot;APEX_050000.WWV_FLOW_WEB_SERVICES&quot;, line 615
  ORA-06512: at &quot;APEX_050000.WWV_FLOW_WEB_SERVICES&quot;, line 657
  ORA-06512: at &quot;APEX_050000.WWV_FLOW_WEBSERVICES_API&quot;, line 202
  ORA-06512: at line 1
  29273. 00000 -  &quot;HTTP request failed&quot;
  *Cause:    The UTL_HTTP package failed to execute the HTTP request.
  *Action:   Use get_detailed_sqlerrm to check the detailed error message.
             Fix the error and retry the HTTP request.
  </code></pre>
  <p>I also do a POST call, before the GET, and it is working perfectly:</p>
  <pre><code>apex_web_service.g_request_headers(1).name := 'Content-Type';
  apex_web_service.g_request_headers(1).value := 'application/json; charset utf-8';
  apex_web_service.g_request_headers(2).name := 'Authorization';
  apex_web_service.g_request_headers(2).value := 'Basic &lt;encoded_user_and_pass&gt;';
  apex_web_service.g_request_headers(3).name := 'Accept';
  apex_web_service.g_request_headers(3).value := 'application/json; charset utf-8';
  apex_web_service.g_request_headers(4).name := 'Content-Length';
  apex_web_service.g_request_headers(4).value := LENGTH(&lt;length&gt;);
      
  v_clob_body := apex_web_service.make_rest_request(
      p_url              =&gt; 'https://secure.p02.eloqua.com/API/Bulk/2.0/customObjects/1/exports',
      p_http_method      =&gt; 'POST',
      p_username         =&gt; null,
      p_password         =&gt; null,
      p_proxy_override   =&gt; '&lt;proxy&gt;',
      p_transfer_timeout =&gt; 900,
      p_body             =&gt; &lt;body&gt;,
      p_body_blob        =&gt; empty_blob(), 
      p_wallet_path      =&gt; '&lt;wallet_path&gt;',
      p_wallet_pwd       =&gt; '&lt;wallet_pwd&gt;');
  </code></pre>
  <p>With Fiddler it works perfectly, for both calls.
  I tried to increase the <code>p_transfer_timeout</code> parameter, but it still doesn't work.
  Has anybody had the same issue when using <code>apex_web_service.make_rest_request()</code>?</p>
  <p>Thank you,
  Iulia</p>