title: How can I avoid "raw variable length too long" errors in SQL Developer?
body: <p>I am updating a BLOB with large mount of text and I get this error:</p>
  
  <pre><code>SQL Error: ORA-06502: PL/SQL: numeric or value error: raw variable length too long
  </code></pre>
  
  <p>Is there any way around it?</p>
  
  <p>The text is 2,670 characters long, being converted via <code>utl_i18n.string_to_raw</code>, as explained in <a href="https://stackoverflow.com/questions/9218474/how-do-i-edit-blobs-containing-json-in-oracle-sql-developer">How do I edit BLOBs (containing JSON) in Oracle SQL Developer?</a>, and is all on one line in the query.</p>
  
  <p><strong>Update:</strong> The BLOB in question already contains text that is 2,686 characters long, which is longer than the text I am trying to insert.</p>