Subject Re: FOR SELECT resultset changed during update statement
Author raivis83
--- In, "Ann W. Harrison" <aharrison@...> wrote:
> On 12/13/2010 6:48 AM, raivis83 wrote:
> >
> > I have noticed one problem with FOR SELECT statement in pl/sql
> >procedure. Correct me if I am wrong but as far as I know ResultSet
> >returned by SELECT statement should remain unchanged while looping
> > through it. But it isn't.
> Yes, your right, and yes, it's non-standard.
> Good luck,
> Ann
Well, thank you Ann. That was very helpful...
Can't find anything about it in FAQ's. If there is anything said about it, i must have been using wrong keywords. Language reference also says nothing about this behavior in FOR SELECT section. So i am considering this as a bug, as it is non-standard SQL behavior and there are no references in any kind of material.