Re: Strange cursor behavior?
From: Vasileios Lourdas <Vasileios.Lourdas_at_eurodyn.com>
Date: Tue, 24 Dec 2002 14:20:37 +0200
Message-ID: <3E085115.268E6DFB_at_eurodyn.com>
Date: Tue, 24 Dec 2002 14:20:37 +0200
Message-ID: <3E085115.268E6DFB_at_eurodyn.com>
Yes,
Tried with exit statement after fetch.
Brian E Dick wrote:
>
> Is this what you tried?
>
> declare
> c pkg.c_type;
> c_rec dual%rowtype;
> begin
> open c for 'select dummy from dual';
> loop
> fetch c into c_rec;
> exit when c%notfound;
> dbms_output.put_line('c is ' || c_rec.dummy);
> end loop;
> close c;
> end;
>
Received on Tue Dec 24 2002 - 13:20:37 CET