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.

You perhaps want to spawn off a completely different process to do that, or http://osi.oracle.com/~tkyte/autonomous/index.html

Otherwise, you are stuck with
http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76965/c23cnsis.htm#2456
>
> Thanks for any help.
>
> -- jetlag --
>
> Oracle Release 9.2

jg

--
_at_home is bogus.
Gee, maybe we could have links in a higher level geometry -
hyperlinks! - and connect documents all over the world in a
planet-wide all-encompassing globe of knowledge... Naw... stoopid
intellectual property laws...