--- In firebird-support@yahoogroups.com, "woodsmailbox"
<cosmin.apreutesei@...> wrote:

>
> --- In firebird-support@yahoogroups.com, Adriano dos Santos Fernandes
> <adrianosf@> wrote:
> >
> > woodsmailbox escreveu:
> > >> Also note that if you had where field = :p (and :p changes) you

are

> > >> going to have different results depending if an index is used or
> not...
> > >
> > > Semantics of code depending on wherever you have indexes or not?
> > > Scary, to say the least.
> > >
> > I done a test in Oracle and result was identical to Firebird.
> >
> >
> > Adriano
> >
>
> Can you please post the oracle version of the test?
>

I was only curious what equivalent construct you could find in oracle
since it doesn't have the "for select" construct. In case it was a
cursor (was it?) AFAIK you can't re-evaluate a cursor from inside the
loop except if you close/open it again.

Anyway, forgive me for insisting on it, but is there any documentation
that deals with the general issue presented here?