Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Performing UPDATE outside of transaction
Hello everyone,
I have a stored procedure running on Tables A, B, C. It is looping through records, performing INSERTs, UPDATEs, etc. All of this is happening within a transaction, so of course other users get a view of the data as it was before the process started, which is what I want. I also need the ability to rollback the transaction if something fails.
The problem is that I would like to have a status table, call it table D, where I update a field to reflect how many records have been processed. I want this table to be visible to other processes so that other users can see the status of the running process. If I put these updates inside the transaction, the users see no change until the COMMIT.
My question is, is what I want to do possible, and if so, how?
Thanks in advance,
Michael Received on Thu Nov 15 2001 - 17:36:59 CST