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

Read syntax diagramSkip visual syntax diagram
>>-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

Copyright© 2019 HCL Technologies Limited