Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_OUTPUT , 2 of 6
This procedure enables calls to PUT
, PUT_LINE
, NEW_LINE
, GET_LINE
, and GET_LINES
. Calls to these procedures are ignored if the DBMS_OUTPUT
package is not enabled.
If there are multiple calls to ENABLE
, then buffer_size
is the largest of the values specified. The maximum size is 1,000,000, and the minimum is 2,000.
DBMS_OUTPUT.ENABLE ( buffer_size IN INTEGER DEFAULT 20000);
Parameter | Description |
---|---|
buffer_size |
Amount of information, in bytes, to buffer. |
pragma restrict_references(enable,WNDS,RNDS);
Error | Description |
---|---|
ORA-20000:, ORU-10027: |
Buffer overflow, limit of < |
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|