DBMS_OUTPUT default buffer size is not allowing to go beyond 1 million bytes (54641)

Chat now with support

Return

Feedback submitted.

Was this article helpful?

[Select Rating]

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.

Feedback submitted.

Was this article helpful?

[Select Rating]

Title