Re: Cursor
Date: 1996/05/23
Message-ID: <4o23bk$hhp_at_mailhost.qsp.co.uk>#1/1
In <31A4728E.2E05_at_chemoil.com>, AravindBR writes:
>In an explicitly declared cursor is it possible to move to the previous
>row ?
>
>Is active set generated by OPENing an explicitly declared cursor
>dynamic. i.e. I declare a cursor and OPEN it, at the same time some
>other user modifies and COMMITs the data in the base table. Will the
>modified data be reflected in the cursor FETCH statements.
>
Unless things have changed a great deal since I last checked, you cannot go backwards through a cursor.
A cursor creates a 'snapshot' of the current data when opening a cursor - any changes that are made by other users will not be reflected in your cursor. If your cursor is intended to be used for future updates, you should lock all of the rows you select via the 'for update' clause. This will stop other users from modifying your data whilst the cursor is still open.
Cheers,
Steve
opinions expressed are mine and do not
necessarily represent those of my employer
Received on Thu May 23 1996 - 00:00:00 CEST