Re: FETCH

"Ivica Dimjasevic" <smokesoft_at_email.hinet.hr> wrote in message news:<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;
> my_rec my_cur%ROWTYPE;
>
> BEGIN
> OPEN my_cur;
>
> LOOP
> FETCH my_cur INTO my_rec;
> EXIT WHEN my_cur%NOTFOUND;
> ...
> END LOOP;
>
> -- Here I want to do it again with different code.
> 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.

No

Regards,

Sybrand Bakker,
Senior Oracle DBA Received on Thu Dec 13 2001 - 10:06:06 CET