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.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
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. |
Considerations
You do not need to call
ENABLEwhen you run OBClient with theSET SERVEROUTPUToption.If
ENABLEis called multiple times, thebuffer_sizeparameter takes the last value passed. Whenbuffer_sizeis notNULL, 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.