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 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-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.