The GET_LINE procedure is used to retrieve information about a specific line from the buffer.
Applicability
The following descriptions apply only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL-compatible mode.
Syntax
DBMS_OUTPUT.GET_LINE (
line OUT VARCHAR2,
status OUT INTEGER);
Parameters
| Parameter | Description |
|---|---|
| line | Returns a buffer line that does not include the last newline character. This parameter is of the VARCHAR2 type, and the size of the VARCHAR2 must be at least 32767 to avoid an error. |
| status | Returns 0 if the call was completed successfully. If no more rows are present in the buffer, 1 is returned. |
Considerations
You can choose to retrieve either a single row or an array of rows from the buffer. Call the GET_LINE procedure to retrieve information from a single-row buffer. To minimize the number of calls to the server, call the GET_LINES procedure to retrieve an array of rows from the buffer.
If you are using OBClient, you can automatically display this information by using the special
SET SERVEROUTPUT ONcommand.After you call GET_LINE, unprocessed line data will be available for the next call to PUT, PUT_LINE, or NEW_LINE.
which has been discarded to avoid confusion with future information.