Oracle: DBMS_SQL.FETCH

dbms_sql.fetch_rows must be called repeatedly to fetch all rows from a select statement.

Return value

The returned value corresponds to the number of records fetched.

When using define_array, a call to fetch_rows returns multiple rows .

When no more rows can be fetched, the function returns 0.