title: Reading clob line by line with pl\sql
body: <p>In my project i use oracle as primary database and i've faced a problem with parsing clob. So suppose we have a clob with value</p>
  
  <pre><code>   aaaaaa
     cccccc
     bbbbbb
  </code></pre>
  
  <p>And it's stored in table test ... </p>
  
  <p>I need to write plsql procedure to get this clob and split it so that i will have array with three items [aaaaaa,cccccccc,bbbbbbb]. </p>
  
  <p>Is there any possible solutions?</p>