GET_LINE procedure

The GET_LINE procedure gets a line of text from the message buffer. The text must be terminated by an end-of-line character sequence.

Syntax

DBMS_OUTPUT.GET_LINE(line ,status)

Procedure parameters

line
An output argument of type VARCHAR(32672) that returns a line of text from the message buffer.
status
An output argument of type INTEGER that indicates whether a line was returned from the message buffer:
  • 0 indicates that a line was returned
  • 1 indicates that there was no line to return