The ENABLE procedure allows the use of the PUT, PUT_LINE, NEW_LINE, and GET_LINE procedures.
If the DBMS_OUTPUT package is not enabled, calls to these procedures will be ignored.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL-compatible mode.
Syntax
DBMS_OUTPUT.ENABLE (
buffer_size IN INTEGER DEFAULT 20000);
Parameters
| Parameter | Description |
|---|---|
| buffer_size | The maximum size of the buffer (in bytes).
|
Considerations
You do not need to call this procedure when you use the
SET SERVEROUTPUToption of OBClient.If multiple
ENABLEprocedures are called, thebuffer_sizeparameter uses the last specified value. When you specifybuffer_size(NOT NULL), the maximum value is 1,000,000, and the minimum value is 2,000.This parameter is usually set to NULL. The default value is 20,000, which is compatible with earlier database versions that do not support unlimited buffering.