Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Cursor Queries

Re: Cursor Queries

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Tue, 24 Aug 1999 11:30:26 +0200
Message-ID: <7ptoon$7ee$1@oceanite.cybercable.fr>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US