The GET_LINE procedure retrieves buffering information for a single line.
Applicability
This section applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition is available only in MySQL compatible mode.
Syntax
DBMS_OUTPUT.GET_LINE (
line OUT VARCHAR2,
status OUT INTEGER);
Parameters
| Parameter | Description |
|---|---|
| line | Returns the buffer information for one line, not including the final newline character. This parameter is of the VARCHAR2 type, and the size of the VARCHAR2 must be at least 32,767 to avoid errors. |
| status | If the procedure completes successfully, the status value is 0. If no more rows exist in the buffer, the status is 1. |
Considerations
You can choose to retrieve single rows or row arrays from the buffer. Call the GET_LINE procedure to retrieve the information of a single row buffer. To reduce server calls, call the GET_LINES procedure to retrieve row arrays from the buffer.
If you use the OBClient, you can choose to display this information automatically by using the
SET SERVEROUTPUT ONcommand.Any unprocessed line data is stored until you call the PUT, PUT_LINE, or NEW_LINE procedure.
The
DELETE_SCHEMA_STATSprocedure was previously discarded to avoid confusion with future information.