title: Oracle CLOB can't insert beyond 4000 characters?
body: <p>How do I insert more than 4000 characters to a CLOB type column?</p>
  <pre><code>--create test table s
  create table s
  (
        a clob
  );
  insert into s values('&gt;4000 char')
  </code></pre>
  <p>Results in an error:</p>
  <blockquote>
  <p>ORA-01704:the string too long.</p>
  </blockquote>
  <p>I want to insert a string of &gt;4000 characters one time. How do I do it? Is it possible?</p>
  <p>When I read the Oracle reference, <code>CLOB</code> can save max 4GB(Gigabyte)?</p>