The ENABLE procedure allows you to call 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 the MySQL-compatible mode.
Syntax
DBMS_OUTPUT.ENABLE (
buffer_size IN INTEGER DEFAULT 20000);
Parameters
| Parameter | Description |
|---|---|
| buffer_size | The maximum buffer size. Valid values:
|
Considerations
When you use the
SET SERVEROUTPUToption of OBClient, you do not need to call this procedure.If multiple ENABLE procedures are called, the
buffer_sizeparameter uses the value specified in the last call. If you specify thebuffer_sizeparameter, the value cannot be greater than 1,000,000 or smaller than 2,000.The parameter is usually set to NULL. The default value is 20,000 to ensure compatibility with earlier database versions that do not support unlimited buffering.