title: string literal too long - how to assign long xml data to clob data type in oracle 11g r2
body: <p>I need to assign a very large xml data of around 30,000 lines to a CLOB data type in oracle database 11g r2. I am using this command in Oracle Sql Developer.</p>
  
  <p>When I use the following command, at first I get 7 prompts for <code>entering quote value</code> and then when statement execution completes, I get - 'string literal too long` error.</p>
  
  <pre><code>update tablename set columnName = 'large xml data' where id=1;
  </code></pre>
  
  <p>I used seven double (single quotes) inside the xml data to escape the single quotes.</p>
  
  <p>How to assign this data to the CLOB column?</p>