The GET_LINE procedure retrieves the buffer information for a single line.
Applicability
This topic applies 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 | Explanation |
|---|---|
| line | Returns the buffered information of one line, excluding the last line break. The parameter is of the VARCHAR2 type and must be at least 32767 in size to avoid an error. |
| status | 0 if the call completed successfully, or 1 if no more rows are available. |
Considerations
You can choose to retrieve a single row or an array of rows from the buffer. Call the GET_LINE procedure to retrieve a single row. To reduce the number of calls to the server, call the GET_LINES procedure to retrieve an array of rows.
If you are using OBClient, you can use the
SET SERVEROUTPUT ONstatement to automatically display this information.Rows that were not retrieved after a call to GET_LINE will be available the next time PUT, PUT_LINE, or NEW_LINE is called.
The previous statements have been deleted to avoid confusion with future statements.