title: Calling a Restful webservice from oracle pl/sql
body: <p>I am calling a <strong>restful</strong> API from <strong>pl/sql</strong>. the restful api is using http not https  but it gives me the following error- </p>
  
  <pre><code>**ORA-29266: end-of-body reached**. I have write the following code---
  
     DECLARE
        lo_req            UTL_HTTP.req;
        lo_resp           UTL_HTTP.resp;
        HTTP_REQ          UTL_HTTP.REQ;
        HTTP_RESP         UTL_HTTP.RESP;
        t_http_resp       UTL_HTTP.resp;
        l_response_text   CLOB;
        v_url             VARCHAR2 (1024);
        pAllparameter     VARCHAR2 (1024);
        vSms              VARCHAR2(1024):='Hellow How Are Yoy';
     BEGIN
        UTL_HTTP.set_detailed_excp_support (TRUE);
        lo_req :=
           UTL_HTTP.
            begin_request ('URL'
              || 'smsText='
              || vSms
              || '&amp;mobileNo='
              || pMobileNo,
              'POST',
              UTL_HTTP.HTTP_VERSION_1_1);
        lo_resp := UTL_HTTP.get_response (lo_req);
      UTL_HTTP.read_text (lo_resp, l_response_text);
        -- A successfull request would have the status code "200".
      -- DBMS_OUTPUT.put_line (l_response_text);
    UTL_HTTP.end_response (lo_resp);
      --  DBMS_OUTPUT.PUT_LINE (pAllparameter);
    EXCEPTION
       WHEN OTHERS
       THEN
          UTL_HTTP.end_response (lo_resp);
           RAISE;
     END;
  </code></pre>
  
  <p>WHEN I Invoke the Procedure It Gives Me Error.   </p>
  
  <p>Please help me..</p>