Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Cursor Queries
Once PL/SQL cursor is open, the set of data is fixed.
This is read consistency. Even, if someone else modify
the rows, Oracle guarantees that you see the same datas
as the opening time.
If you want your set of data updated, you have to close
and reopen your cursor.
wnmurthy_at_yahoo.com a écrit dans le message <7ptk94$inq$1_at_nnrp1.deja.com>...
>Hi,
>I want to know if I can have the cursor updated automatically during
>the execution of the program even though the cursor is open and I dont
>have to close it and open it again. Assuming that the cursor is opened
>statically?
>If Yes,How?
>
>Thanks in advance and hoping to get some answers!
>
>Regards,
>DejaWnm
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Tue Aug 24 1999 - 04:30:26 CDT