Shulou(Shulou.com)06/01 Report--

1. Buffer overflow,limit of 10000 bytes

Declare

Begin

For c in 1..1000 loop

Dbms_output.put_line ('test')

End loop

End

The default buffer size is 10000 bytes. There are 6000 Chinese characters in 1000 cycles, that is, 12000 bytes. Set the buffer size in the output tab of the SQL window.

Number or value error: the string buffer is too small

Declare

V varchar2: =''

Begin

For c in 1..1000 loop

VRV = v | | 'test'

End loop

End

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.