The GET_LINES procedure is used to retrieve a set of row data from the buffer.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Syntax
DBMS_OUTPUT.GET_LINES (
lines OUT CHARARR,
numlines IN OUT INTEGER);
DBMS_OUTPUT.GET_LINES (
lines OUT DBMSOUTPUT_LINESARRAY,
numlines IN OUT INTEGER);
Parameters
| Parameter | Description |
|---|---|
| lines | The buffer information of multiple rows. The maximum length of each row in the group is 32767 bytes. |
| numlines | The number of rows to retrieve from the buffer. After retrieving the specified number of rows, the procedure returns the actual number of rows retrieved. If this number is less than the requested number, it indicates that there are no more rows in the buffer. |
Considerations
You can choose to retrieve one row or a set of rows from the buffer. Call the
GET_LINEprocedure to retrieve single-row buffer information. TheGET_LINESprocedure reduces the number of calls to the server.After calling
GET_LINEorGET_LINES, any un-retrieved row data will be discarded before the next call toPUT,PUT_LINE, orNEW_LINEto avoid confusion with future information.