The GET_LINE stored procedure retrieves the buffer information for a line.
Usage scenario
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support this feature.
Syntax
DBMS_OUTPUT.GET_LINE (
line OUT VARCHAR2,
status OUT INTEGER);
Parameters
| Parameter | Description |
|---|---|
| line | Return a buffer of one line, excluding the last newline character. This parameter is of the VARCHAR2 type, and its size must be greater than or equal to 32767 to avoid errors. |
| status | If the procedure succeeds, the status return value is 0. If there are no more rows in the buffer, the value is 1. |
Considerations
You can retrieve information from the buffer for a single line or a group of lines. Use the GET_LINE procedure to retrieve a line buffer. To reduce the number of server calls, use the GET_LINES procedure to retrieve a line buffer for a group of lines.
If you use OBClient, you can use the special
SET SERVEROUTPUT ONcommand to automatically display this information.Data from lines that were not retrieved after calling GET_LINE will be available during the next call to the PUT, PUT_LINE, or NEW_LINE procedure.
They are discarded to prevent confusion with future information.