Re: Cursors

On Tue, Jun 14, 2011 at 11:54 PM, Andy Chambers <achambers(at)mcna(dot)net> wrote:
> Hi,
>
> What happens to cursors when new data is added to a table after you
> start iterating
> over its rows?
>
> For example, given the following loop...
>
> for rule in select tc.sid, tc.s, td.rule, td.returns
>                     from tcell tc
>               inner join tcelldef td on (tc.p = td.p)
>                    where tc.iasid = current_audit_sid()
>                       or committed_sid in ( select committed
>                                               from tcellread tcr
>                                              where tc.sid = tcr.tcell )
>                         for update of tc loop
>  ...
> end loop;
>
> some code in the loop might add a record into tcellread that causes the where
> condition to become true for a row in which it was previously false.
> Will the cursor
> eventually see it?

nope!

merlin