title: How to sent a POST request as json in plsql
body: <p>I have the following basic code which i use to post a plsql json request. The webservice getting executed doesnt have any response as it is simply for carrying out a certain task.
  But each time i execute the block, i get the status code 400 from Apache Tomcat.
  Where is it that i am going wrong? </p>
  
  <pre><code>declare
    http_resp utl_http.resp;
    http_req utl_http.req;
    json_msg VARCHAR2(500);
  begin
  
    http_req := utl_http.begin_request('http://192.168.1.194:8080/NotificationApp/sendNotification.rest', 'POST');
    utl_http.set_body_charset(http_req, 'UTF-8');
    utl_http.set_header(http_req, 'Content-Type', 'application/json');
  
      json_msg := '{"code":100,"id": "APA91bFSmD_gBsUwP_hraRZL20mt8p4ejGn5fC7tlciINT50Ad8oIod2T-64GVk_8rrjoqXGEpYuRcoQogG0L7aOKIjeeisTcmHiUUONbnZzn4_u0ED7QD_iNeVkh2RU8Pa-HBHwgJUgOT-TyvlM9hB4Yn9fvWER","data": "alert alert"}';
  
    utl_http.write_text(http_req, dbms_lob.substr(json_msg,dbms_lob.getLength(json_msg),1));
  
   http_resp := utl_http.get_response(http_req);
  
    if (http_resp.status_code &gt;= 400) and
              (http_resp.status_code &lt;= 499)
          then
          dbms_output.put_line(http_resp.status_code);
  
          end if;
  
    utl_http.end_response(http_resp);
  
  end;
  </code></pre>
  
  <p>Thanks in advance</p>