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 does not support this feature.
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, this procedure returns the actual number of rows retrieved. If this number is less than the requested number of rows, it indicates that there are no more rows in the buffer. |
Considerations
You can choose to retrieve one or more 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, the unretrieved row data will be discarded before the next call toPUT,PUT_LINE, orNEW_LINEto avoid confusion with future information.