ENABLE procedure - Enable the message buffer
The ENABLE procedure enables the message buffer. During a single session, applications can put messages in the message buffer and get messages from the message buffer.
Syntax
Procedure parameters
- buffer_size
- An input argument of type INTEGER that specifies the maximum length of the message buffer in bytes. If you specify a value of less than 2000 for buffer_size, the buffer size is set to 2000. If the value is NULL, then the default buffer size is 20000.
Authorization
EXECUTE privilege on the DBMS_OUTPUT module.
Example
The following example enables the message buffer:
CALL DBMS_OUTPUT.ENABLE( NULL )@
Usage notes
You can call the ENABLE procedure to increase the size of an existing message buffer. Any messages in the old buffer are copied to the enlarged buffer.