title: how to insert long string oracle clob or blob
body: <p>How I can insert very long text <code>100000 &lt;length(string) &lt; 300000</code> oracle clob or blob?</p>
  
  <pre><code>DECLARE
      v_long_text CLOB;
  BEGIN
      v_long_text := 'my long string text';
  
      INSERT INTO MYTABLE_NAME 
      VALUES      (v_long_text);
  END;
  </code></pre>
  
  <p>its metod is not worked, returned error <code>PLS-00172: string literal too long</code></p>