понедельник, 1 апреля 2013 г.

Read data from clob

Read data from clob:
  1. declare
  2. v_body clob;
  3. offset number := 1;
  4. v_str varchar(32767);
  5. amount number := 32767;
  6. begin
  7. v_body := rpad('Big clob data ', 32767 * 4, 'Big clob data ');
  8. while(offset <= dbms_lob.getlength(v_body)) loop
  9. dbms_lob.read(v_body, amount, offset, v_str);
  10.  
  11. -- Operate with v_str:
  12. --dbms_output.put_line(v_str);
  13.  
  14. offset := offset + amount;
  15. end loop;
  16. end;