DBMS_OUTPUT输出提示超过2000,会报错,可以用循环输出办法解决:
v_Num := 1;
WHILE v_Num <= LENGTH(v_Sql) LOOP
Dbms_Output.Put_Line(SUBSTR(v_Sql, v_Num, 2000));
v_Num := v_Num + 2000;
END LOOP;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25475930/viewspace-2124630/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25475930/viewspace-2124630/