DBMS OUTPUT

DBMS_OUTPUT

The DBMS_OUTPUT package provides an interface in which the user can print the stored character strings in the buffer to clients.

The procedure and functions comprised of the DBMS_OUTPUT package are as shown in the following table.

Procedures/Functions	Description
NEW_LINE	Prints a character string stored in the buffer along with new-line characters.
PUT	Stores a character string in the buffer.
PUT_LINE	Prints a character string stored in the buffer.

NEW_LINE

The NEW-LINE procedure prints new-line characters( \n for Unix).

Syntax

DBMS_OUTPUT.NEWLINE;

Parameter

None

Return Value

Because it is a stored procedure, there is no return value.

Exception

There is no exception.

PUT

The PUT is a function storing a characteristic string in the buffer.

Syntax

DBMS_OUTPUT.PUT(str IN VARCHAR(65534));

Parameter

Name	In/Output	Data Type	Description
str	IN	VARCHAR(65534)	The buffer in which the character string to store read from a file

Result Values

Because it is a stored procedure, there is no return value.

Exception

There is no exception.

PUT_LINE

The PUT_LINE is function which outputs by attaching the new-line characters ( \n for Unix) to the character strings printed in the buffer.

Syntax

DBMS_OUTPUT.PUT_LINE(str IN VARCHAR(65533));

Parameter

Name	In/Output	Data Type	Description
str	IN	VARCHAR(65534)	The buffer in which the character string to store read from a file.

Return Value

Because it is a stored procedure, there is no return value.

Exception

There is no exception.