• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Stored Procedures
  5. Advanced Packages
  6. DBMS_OUTPUT

DBMS_OUTPUT

Related Interfaces

Table 1 provides all interfaces supported by the DBMS_OUTPUT package.

Table 1 DBMS_OUTPUT

API

Description

DBMS_OUTPUT.PUT_LINE

Outputs specified texts.

DBMS_OUTPUT.PUT

Outputs the specified text to the front of the specified text without adding a linefeed.

DBMS_OUTPUT.ENABLE

Sets the size of the output buffer. If the size is not specified, it contains a maximum of 2000 bytes.

  • DBMS_OUTPUT.PUT_LINE

The PUT_LINE procedure writes a row of text carrying a line end symbol in the buffer. The DBMS_OUTPUT.PUT_LINE function prototype is:

DBMS_OUTPUT.PUT_LINE (
item IN VARCHAR2);
Table 2 DBMS_OUTPUT.PUT_LINE interface parameters

Parameter

Description

item

Specifies the text that was written to the buffer.

  • DBMS_OUTPUT.PUT

The stored procedure PUT outputs the specified text to the front of the specified text without adding a linefeed. The DBMS_OUTPUT.PUT function prototype is:

DBMS_OUTPUT.PUT (
item IN VARCHAR2);
Table 3 DBMS_OUTPUT.PUT interface parameters

Parameter

Description

item

Specifies the text that was written to the specified text.

  • DBMS_OUTPUT.ENABLE

The stored procedure ENABLE sets the output buffer size. If the size is not specified, it contains a maximum of 2000 bytes. The DBMS_OUTPUT.ENABLE function prototype is:

DBMS_OUTPUT.ENABLE (
buf IN INTEGER);
Table 4 DBMS_OUTPUT.ENABLE interface parameters

Parameter

Description

buf

Sets the buffer area size.

Examples

BEGIN
    DBMS_OUTPUT.ENABLE(50);
    DBMS_OUTPUT.PUT ('hello, ');
    DBMS_OUTPUT.PUT_LINE('database!');-- Displaying "hello, database!"
END;
/