String split for a CLOB value and insert splitted strings after a certain position as new row
<p>I have a string in which there are several sentences seperated by ';'.
I need a solution to split the string into seperate rows and insert them into another table.</p>

<p>The condition to split the string should be as follows:</p>

<blockquote>
  <p>The string length should accomodate atmost 699 characters and end at the nearest ';' character as that marks the end of a statement and we wont want it to end midway.</p>
</blockquote>

<p>For example:If we have a string like "abcdefg;thjiksfg;a;" 
and we want our string length to be atmost 12chars 
then the resulting rows after split and processing should have values like </p>

<pre><code>row1:abcdefg; 
row2:thjiksfg;a; 
</code></pre>

<p>Please suggest how can I do it using a pl/sql procedure.</p>

<p>The current string is stored in a table as a CLOB value as it can accommodate as much as 7000/8000 characters.</p>

<p>Any help regarding this is much appreciated.</p>