5024: FOR msg_rec in msg_cur(l_min_creation_date)
5025: LOOP
5026: l_loop_count := l_loop_count +1;
5027: l_amount := null;
5028: l_amount := dbms_lob.getlength(msg_rec.body_text);
5029: l_msg_text := null;
5030:
5031: dbms_lob.read(
5032: lob_loc => msg_rec.body_text,
5027: l_amount := null;
5028: l_amount := dbms_lob.getlength(msg_rec.body_text);
5029: l_msg_text := null;
5030:
5031: dbms_lob.read(
5032: lob_loc => msg_rec.body_text,
5033: amount => l_amount,
5034: offset => 1,
5035: buffer => l_msg_text );