FETCH_ROWS

The FETCH_ROWS function is used to retrieve a row of data from the specified cursor.

You can call the FETCH_ROWS function repeatedly until all rows are fetched. These rows are stored in a buffer and must be read by calling COLUMN_VALUE for each column after each call to FETCH_ROWS.

The FETCH_ROWS function takes the cursor ID as input and returns the number of rows actually fetched.

Syntax

DBMS_SQL.FETCH_ROWS (c IN INTEGER)
RETURN INTEGER;

Parameters

Return value

A row of data from the specified cursor.