The ENABLE stored procedure enables calls to PUT, PUT_LINE, NEW_LINE, and GET_LINE.
If the DBMS_OUTPUT package is not activated, calls to these programs are ignored.
Syntax
DBMS_OUTPUT.ENABLE (
buffer_size IN INTEGER DEFAULT 20000);
Parameters
| Parameter | Description |
|---|---|
| buffer_size | The maximum amount of buffered information in bytes. To set the buffer size to unlimited, set buffer_size to NULL. |
Usage notes
You do not need to call ENABLE when you run OBClient with the
SET SERVEROUTPUToption.If ENABLE is called multiple times, the
buffer_sizeparameter takes the last value passed. Whenbuffer_sizeis not NULL, it must be within the range of 2,000 to 1,000,000.In most cases, this parameter is set to NULL. The default value 20,000 is chosen to provide backward compatibility with earlier database versions that do not support unlimited buffering.