The GET_LINES procedure retrieves a set of rows of data from the buffer.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL-compatible 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 is 32767 bytes. |
| numlines | The number of rows to retrieve from the buffer. After retrieving the specified number of rows, this 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 you call
GET_LINEorGET_LINES, the rows that are not retrieved are discarded before the next call toPUT,PUT_LINE, orNEW_LINEto avoid confusion with future information.