Re: Temporarily disabling read consistency

jetlag11235_at_yahoo.com (Jetlag) wrote in message news:<2eeed00e.0302070654.1aba68ae_at_posting.google.com>...
> Is it possible to disable the read consistency in Oracle for a
> particular SELECT statement?
>
> Roughly, I have a PL/SQL procedure with a primary cursor which selects
> a field F from a table T. As I am iterating through the rows, a
> secondary cursor updates the field F in table T for a particular row,
> often not read yet by the first cursor. I would like for the first
> cursor to read the new value when it gets to an updated field.
>
> Thanks for any help.
>
> -- jetlag --
>
> Oracle Release 9.2

This is not possible. Read Concepts book. Received on Fri Feb 07 2003 - 19:38:47 CET