Return
-
Title
DBMS_OUTPUT default buffer size is not allowing to go beyond 1 million bytes -
Description
I am unable to set the default DBMS_OUTPUT buffer size to a value higher than 1,000,000 bytes in View | Options | Oracle | General
-
Cause
In SQL*PLUS the maximum value that can be set for the buffer size is 1,000,000. However it can also be set to unlimited but Toad currently does not allow this.
-
Resolution
Upgrade to the latest version of Toad which sets the default buffer size to 'Unlimited'. You can download here.