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. These row data are stored in a buffer, and can only be read by calling COLUMN_VALUE, for each column, after each call to FETCH_ROWS.
The FETCH_ROWS function accepts the ID of the cursor to fetch, and returns the number of rows actually fetched.
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.