SQL Script. (xxxx.sql)

SET PAGESIZE  100000
SET HEADING   OFF
SET TERM      OFF
SET FEEDBACK  OFF
SET SERVEROUTPUT ON SIZE 200000
SPOOL 路径+文件名
EXEC procedurename
SPOOL         OFF

ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes错误解决
SET SERVEROUTPUT ON SIZE 200000