sql - How to increase dbms_output buffer? -

i tried debug dynamic query via dbms_output seems query string long dbms_output buffer.

i got :

ora-06502: pl/sql: numeric or value error: character string buffer small ora-06512: @ "sys.dbms_output", line 148 ora-06512: @ line 1  

any idea how increase buffer size ?

you can enable dbms_output , set buffer size. buffer size can between 1 , 1,000,000.

dbms_output.enable(buffer_size in integer default 20000); exec dbms_output.enable(1000000); 

check this

edit

as per comment posted frank , mat, can enable null

exec dbms_output.enable(null); 

buffer_size : upper limit, in bytes, amount of buffered information. setting buffer_size null specifies there should no limit. maximum size 1,000,000, , minimum 2,000 when user specifies buffer_size (not null).