Temporarily disabling read consistency
From: Jetlag <jetlag11235_at_yahoo.com>
Date: 7 Feb 2003 06:54:45 -0800
Message-ID: <2eeed00e.0302070654.1aba68ae_at_posting.google.com>
Date: 7 Feb 2003 06:54:45 -0800
Message-ID: <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.
Oracle Release 9.2 Received on Fri Feb 07 2003 - 15:54:45 CET