set serveroutput on format wrapped; declare my_var long; begin for x in ( select from where … ) loop my_var := dbms_lob.substr( x., 32000, 1 ); DBMS_OUTPU…