On Tue, Jun 14, 2011 at 11:54 PM, Andy Chambers <achambers@mcna.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