v_field1 mytable.field1%TYPE;
v_field2 mytable.field2%TYPE;

v_row mytable%ROWTYPE;

-- DECLARE THE CURSOR

CURSOR C1 IS
SELECT * FROM mytable
where field1 = v_field1
and field2 = v_field2;

BEGIN
-- OPEN A PREVIOUSLY DECLARED CURSOR
OPEN C1;

LOOP
FETCH C1 INTO v_row;

EXIT WHEN C1%NOTFOUND;
END LOOP;

CLOSE C1;
-- CLOSE THE CURSOR
END;

Using a While Structure to Fetch Rows

v_field1 mytable.field1%TYPE;
v_field2 mytable.field2%TYPE;

v_row mytable%ROWTYPE;

-- DECLARE THE CURSOR

CURSOR C1 IS
SELECT * FROM mytable
where field1 = v_field1
and field2 = v_field2;

BEGIN
-- OPEN A PREVIOUSLY DECLARED CURSOR
OPEN C1;

FETCH C1 INTO v_row;

WHILE C1%FOUND LOOP
FETCH C1 INTO v_row;
END LOOP;

CLOSE C1;
-- CLOSE THE CURSOR
END;

Аналогичная проблема