oracle中long value取值

SET SERVEROUTPUT ON

v_DynSQL为vachar2类型,但拼接的输出语句过大,后台无法打印输出.用以下语句进行分行打印:

v_sql varchar2(4000);
    v_n   pls_integer := 1; 

loop
    v_sql := substr(v_DynSQL, v_n, 1000);
    dbms_output.put_line(v_sql);
   
    v_n := v_n + 1000;   
    exit when v_n > length(v_DynSQL);
end loop;