Re: Temporarily disabling read consistency

Not as far as I know. That's the whole point of transactions. Either they are complete successfully or they don't and to have some other process make a decision based upon a situation that is not yet decided (not yet committed or rolledback) seeems to me to defeat the purpose of having a commercial quality RDBMS.
Jim

--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family.  Remove the negative part, keep the minus sign.  You can figure
it out.
"Jetlag" <jetlag11235_at_yahoo.com> 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