Character buffer related errors in Oracle

I. Buffer overflow,limit of 10000 bytes
Declare
Begin
For C in 1..1000 Loop
Dbms_output.put_line (' Test and test test ');
End Loop;
End
The default size of the buffer is 10000 bytes. Loop 1000 times on a total of 6,000 Chinese characters, namely 12000 bytes. Set the buffer size in the Output tab of the SQL window.

Two, numeric, or value error: The string buffer is too small
Declare
V VARCHAR2 (100): = ";
Begin
For C in 1..1000 Loop
V:= V | | ' Test test ';
End Loop;
End

This article is from the "It Xu Fat column" blog, please be sure to keep this source http://woshixy.blog.51cto.com/5637578/1416416