oracle - Reading clob line by line with pl\sql - Stack Overflow
Emmanuel's Answer This is an elegant solution that works just fine with clobs exceeding 32767 chars or lines exceeding 4K characters. ANSI Standard Query: DECLARE v_tmp clob :='aaaa'||chr(10)|| 'bbb'||chr(10)|| 'ccccc'; BEGIN FOR rec IN ......