title: Working with dbms_lob.copy and error ORA-06502:
body: <p>I am bit lost with working with <code>dbms_lob.copy</code></p>
  
  <pre><code>CREATE OR REPLACE PROCEDURE Ex_PRC IS
   dest_lob CLOB;
   src_lob  CLOB;
  BEGIN
  
    SELECT F_CLOB INTO dest_lob
    FROM EX_EMPLOYEE
    WHERE id = 1;
  
  dbms_lob.copy (dest_lob, src_lob, 30, 1, 1);
    COMMIT;
  END;
  </code></pre>
  
  <p>/</p>
  
  <p>I got error 
  <code>numeric or value error invalid lob locator specified ora-22275</code></p>
  
  <p>I followed up this <a href="https://stackoverflow.com/questions/13648830/split-blob-file/13680419#13680419">SO</a> answer because thats what I needed is to split the blob and move them .but I didnt understand why he used  <code>dbms_lob.createtemporary</code></p>