DBE_OUTPUT

APIs

Table DBE_OUTPUT provides all APIs supported by the DBE_OUTPUT package.

• DBE_OUTPUT.PRINT_LINE

The stored procedure PRINT_LINE writes a row of text carrying a line end symbol in the buffer. The prototype of the DBE_OUTPUT.PRINT_LINE function is as follows:

1
2

DBE_OUTPUT.PRINT_LINE (
format IN VARCHAR2);

• DBE_OUTPUT.PRINT

The stored procedure PRINT outputs the specified text to the front of the specified text without adding a newline character. The prototype of the DBE_OUTPUT.PRINT function is as follows:

1
2

DBE_OUTPUT.PRINT (
format IN VARCHAR2);

• DBE_OUTPUT.SET_BUFFER_SIZE

The stored procedure SET_BUFFER_SIZE sets the output buffer size. If the size is not specified, it contains a maximum of 20000 bytes. The prototype of the DBE_OUTPUT.SET_BUFFER_SIZE function is as follows:

1
2

DBE_OUTPUT.SET_BUFFER_SIZE (
size IN INTEGER default 20000);

Examples

1
2
3
4
5
6

BEGIN
    DBE_OUTPUT.SET_BUFFER_SIZE(50);
    DBE_OUTPUT.PRINT('hello, ');
    DBE_OUTPUT.PRINT_LINE('database!');-- Output "hello, database!".
END;
/