oracle 超长度输出

oracle 超出255长度限制输出，有时为了检查动态sql就需要时，就需要打印一下。

范例：

declare
v_num   number;
v_count number;
v_sql   varchar2(2000);--需要打印的sql
begin
    v_sql:='LOOP
          FETCH v_tempCur
            INTO v_tab_cms_bank_trans.v_cmsid,v_tab_cms_bank_trans.v_cur_sign,v_tab_cms_bank_trans.v_transfer_date,
            v_tab_cms_bank_trans.v_out_account,v_tab_cms_bank_trans.v_out_bank_no,
            v_tab_cms_bank_trans.v_in_account,v_tab_cms_bank_trans.v_in_bank_no,v_tab_cms_bank_trans.v_trans_sum,
            v_tab_cms_bank_trans.v_cms_return_code;
            
            v_drawdata_confirm(v_tempCur%ROWCOUNT):= v_tab_cms_bank_trans;    
          EXIT WHEN v_tempCur%NOTFOUND;
        END LOOP;
     CLOSE v_tempCur;';
    v_num := lengthb(v_sql)/254;
    v_count:=trunc(v_num);
    if v_num>v_count then
       v_num:=v_count+1;
    else 
       v_num:=v_count;
    end if;
    for i in 1..v_num
    loop
          dbms_output.put_line(Substr(v_sql,254*(i-1),254));
		end loop;
end;