FETCH
From: Ivica Dimjasevic <smokesoft_at_email.hinet.hr>
Date: Wed, 12 Dec 2001 13:10:20 +0100
Message-ID: <9v7hft$9hq6$1_at_as201.hinet.hr>
Date: Wed, 12 Dec 2001 13:10:20 +0100
Message-ID: <9v7hft$9hq6$1_at_as201.hinet.hr>
Hi! Let say I have PL/SQL procedure:
CREATE OR REPLACE my_proc IS
CURSOR my_cur SELECT * FROM my_table;
BEGIN
LOOP
my_rec my_cur%ROWTYPE;
OPEN my_cur;
FETCH my_cur INTO my_rec;
EXIT WHEN my_cur%NOTFOUND;
...
END LOOP;
FETCH my_cur INTO my_rec;
EXIT WHEN my_cur%NOTFOUND;
...
END LOOP;
CLOSE my_cur;
END;
Is it possible to FETCH all rows again from the beginning without closing
and reopening cursor?
Thanks.
-- Ivica Dimjasevic http://come.to/smokesoft/Received on Wed Dec 12 2001 - 13:10:20 CET