Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: changing the isolation level
On Sun, 04 Feb 2007, lehmannmapson_at_cnm.de wrote:
> Hello,
>
>>>Think of a script, that generates invoices montly. Lets say you have >>>a average volume of $1000 dollar. So if a run of the script in the >>>next month just returns a volume of $200 you can be pretty sure, that >>>something has gone wrong. But if you cannot see this until you >>>confirmed all the stuff, then it is too late to revoke it. >> Then in ORACLE use a staging table. >> the load application loads the staging table and commits. (it >> can even >> exit at this point.) >> the validation application reads the staging table and approves >> the >> changes by inserting them in the final tables, or disapproves (maybe >> generates error reports?), and finally deletes the rows from the >> staging table.
Then your two processes need to share the same connection. Plain and simple. There is never a reason to read uncommitted data outside the process which is holding the transaction.
-- Galen BoyerReceived on Sun Feb 04 2007 - 10:56:18 CST