433:
434: FOR msg_rec in msg_cur (l_freeze_date)
435: LOOP
436: l_amount := null;
437: l_amount := dbms_lob.getlength(msg_rec.body_text);
438: l_msg_text := null;
439: l_item_id := null;
440:
441: dbms_lob.read(
437: l_amount := dbms_lob.getlength(msg_rec.body_text);
438: l_msg_text := null;
439: l_item_id := null;
440:
441: dbms_lob.read(
442: lob_loc => msg_rec.body_text,
443: amount => l_amount,
444: offset => 1,
445: buffer => l_msg_text );
780:
781: FOR msg_rec in msg_cur(l_freeze_date)
782: LOOP
783: l_amount := null;
784: l_amount := dbms_lob.getlength(msg_rec.body_text);
785: l_msg_text := null;
786: l_item_id := null;
787:
788: dbms_lob.read(
784: l_amount := dbms_lob.getlength(msg_rec.body_text);
785: l_msg_text := null;
786: l_item_id := null;
787:
788: dbms_lob.read(
789: lob_loc => msg_rec.body_text,
790: amount => l_amount,
791: offset => 1,
792: buffer => l_msg_text );