- declare
- v_body clob;
- offset number := 1;
- v_str varchar(32767);
- amount number := 32767;
- begin
- v_body := rpad('Big clob data ', 32767 * 4, 'Big clob data ');
- while(offset <= dbms_lob.getlength(v_body)) loop
- dbms_lob.read(v_body, amount, offset, v_str);
- -- Operate with v_str:
- --dbms_output.put_line(v_str);
- offset := offset + amount;
- end loop;
- end;