The FETCH_ROWS function fetches one row of data from a specified cursor.
You can call the FETCH_ROWS function repeatedly until all rows are fetched. The row data is stored in a buffer and can only be read by calling COLUMN_VALUE for each column after each FETCH_ROWS call.
The FETCH_ROWS function accepts the ID of the cursor to fetch, and returns the number of rows actually fetched.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Syntax
DBMS_SQL.FETCH_ROWS (c IN INTEGER)
RETURN INTEGER;
Parameters
| Parameter | Description |
|---|---|
| c | The ID of the cursor. |
Return values
A row from the specified cursor is returned.