PUT_LINE

The PUT_LINE procedure is used to put a single line of data into the buffer.

Syntax

DBMS_OUTPUT.PUT_LINE (
item IN VARCHAR2);

Parameters

Considerations

• You can build an information line in segments by calling PUT multiple times, or you can call PUT_LINE to put the entire line of information into the buffer.

• After you call PUT_LINE, a line terminator is automatically added. If you create a line by calling PUT, you must call NEW_LINE to add a line terminator. GET_LINE and GET_LINES do not return lines that are not terminated by a newline character.

• If the number of lines exceeds the limit, an error message is returned.

• Output created by using PUT or PUT_LINE is buffered. You cannot retrieve the output until the PL program unit that generates the buffered output returns to its caller.

  For example, OBClient does not display DBMS_OUTPUT messages until the PL program completes. There is no mechanism in the PL program to refresh the DBMS_OUTPUT buffer.

  obclient> SET SERVEROUTPUT ON;
  obclient> BEGIN
      DBMS_OUTPUT.PUT_LINE ('hello');
      DBMS_LOCK.SLEEP (10);
      END;