DBMS_OUTPUT

Related Interfaces

Table 1 provides all interfaces supported by the DBMS_OUTPUT package.

• 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:

1
2

DBMS_OUTPUT.PUT_LINE (
item IN VARCHAR2);

• 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:

1
2

DBMS_OUTPUT.PUT (
item IN VARCHAR2);

• DBMS_OUTPUT.ENABLE

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

1
2

DBMS_OUTPUT.ENABLE (
buf IN INTEGER);

Examples

1
2
3
4
5
6

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