The active set pointer is set to the first row.
Based on the values of the bind variables, the active set (the query result) is determined. When a cursor is opened, the following things happen: The values of the bind variables are examined. With each iteration, the cursor FOR LOOP statement fetches a row from the result set into the record.
The cursor FOR LOOP statement implicitly declares its loop index as a record variable of the row type that a specified cursor returns, and then opens a cursor.
