ORA-20000: ORU-10027: buffer overflow, limit of 15000 bytes

프로시저에서 커서를 loop로 돌리는데 발생한 에러..;;

# DBMS_OUTPUT Errors

 

DBMS_OUTPUT subprograms raise the application error ORA-20000, 
and the output procedures can return the following errors:

 

ORU-10027 : Buffer overflow  
ORU-10028 : Line length overflow  

 
해결 1>

 

set SERVEROUTPUT ON SIZE n

 

SIZE sets the number of bytes of the output that can be buffered within the Oracle8i or Oracle9i database server. The default for n is 2000. n cannot be less than 2000 or greater than 1,000,000.

 

해결 2>

 

exec DBMS_OUTPUT.ENABLE (n);