title: Error at line 1, col 1: Unexpected character "<" in Apex oracle
body: <p>when I send a file to another database, I get a response, I parse it with the command <code>apex_json.parse (v_clob_post);</code> and write down the change I need. But there is an error that I cannot resolve:</p>
  
  <blockquote>
    <p>ORA-20987: Error at line 1, col 1: Unexpected character" &lt;"</p>
  </blockquote>
  
  <p>How can I solve this?</p>
  
  <p>My code:</p>
  
  <pre><code>set serveroutput on
  Declare     
  v_clob_post     CLOB;
  v_clob          CLOB;
  l_body_b        BLOB;
  g_EXTERNAL_ID  varchar2(300);   
  v_count int;
  BEGIN 
  
    for r in (select id from SEC_OBJECT)
  
    loop  
  
      select MYFILE INTO l_body_b from SEC_OBJECT  where id = r.id;
      apex_json.initialize_clob_output;
      apex_json.open_object;
      apex_json.write('snapshot', blob_to_clob_base64(l_body_b)); 
      apex_json.close_object;
      V_clob  := apex_json.get_clob_output;
      apex_json.free_output;
     if   l_body_b is not null then
                      apex_web_service.g_request_headers(1).name := 'Content-Type';  
                      apex_web_service.g_request_headers(1).value := 'application/json';  
                      v_clob_post  := apex_web_service.make_rest_request(p_url =&gt; 'myURL',p_http_method =&gt; 'POST'
                      ,p_body =&gt;  v_clob );
     if apex_web_service.g_status_code != 200 then
        dbms_output.put_line('id ' || r.id || ' status ' || apex_web_service.g_status_code);
        dbms_output.put_line(v_clob_post);
      else
        apex_json.parse(v_clob_post);     
      end;
  
  
   apex_json.parse(v_clob_post);     
   g_EXTERNAL_ID := apex_json.get_varchar2(p_path =&gt; 'id_document'); 
   update SEC_OBJECT set EXTERNAL_ID = g_EXTERNAL_ID where id = r.id;
      end if;
  end loop;
  end;
  /
  </code></pre>
  
  <p>My answer (JSON I’m parsing):</p>
  
  <pre><code>successful: true
  id_document: "112118e18"
  </code></pre>